If I have a huge data set and have filtered out all of the data I don't want to see, is there a way I can switch between the two easily? I'll move the unwanted to a new sheet.
Can filter selections be saved and applied to several sheets?
If I have a huge data set and have filtered out all of the data I don't want to see, is there a way I can switch between the two easily? I'll move the unwanted to a new sheet.
Can filter selections be saved and applied to several sheets?
Hi,
Please try Custom Auto Filter option.
I think this should be help you.
Rahul
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Hi thanks very much. By chance I just found this and custom text filtering 'Contains' "XYZ" is very useful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks