I have data with 5000 rows, I filter the rows to be left with 100-200 rows.
My question is :
Is it possible to set predefined filters and only keep the filtered rows, the rest should be deleted (not even hidden)
I tried using advance filter but after I filter everything goes blank.
EDIT:
How I plan to use the file:
1) download raw data from web
2) copy and paste the data in my excel workbook
3) click 1 button to filter the data as per my pre defined conditions
or
4) just paste the data and upon pasting only the filtered data remains, rest is deleted.
Any help on this will be greatly appreciated.
Thanks & regards,
Mukul
Bookmarks