Filter and save result

  • Thread starter Thread starter annoni
  • Start date Start date
A

annoni

After filtering a list, how do I save only the filtered result "as it is" on
the same sheet and discard the rest? Please help...thanks.
 
Paste it unto a new sheet and discard the old, or reverse the filter so you
gat everything except what
you intended to filter for and then delete all rows


--


Regards,


Peo Sjoblom
 
Thanks...Now I have a question about reverse filter...Is there a short cut or
a formula to do this or do I have to manually filter and delete "reverse"
items?
 
There is nothing built in, you would need for instance if you
previously filtered for records greater than 200, then you
would need to use less than or equal to 200, select the range and delete
them. You would probably be better off using the advanced filter
where you can filter to another sheet


http://www.contextures.com/xladvfilter01.html


look at the extract data to another sheet



Finally you could record a macro to automate it


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter and save result 8
Macro to copy value in field and insert it into filter 2
VBA: How can I use a string variable as autofilter criteria? 4
Filters 5
Excel vba code to match duplicates 4
Filling cells with filtered data to another sheet. 2
How come my filter does not work? 1
How can we group rows? I have problem.... 2

Back
Top