Filter and save result

[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.

 

[Peo Sjoblom]

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

 

[annoni]

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?

 

[Peo Sjoblom]

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