Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Filter and save result

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.


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,268
Default Filter and save result

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" wrote in message
...
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.




  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Filter and save result

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" wrote:

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" wrote in message
...
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.





  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,268
Default Filter and save result

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


"annoni" wrote in message
...
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" wrote:

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" wrote in message
...
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.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filter and save result annoni Excel Discussion (Misc queries) 8 September 10th 08 04:09 AM
how do i auto copy the result of a filter ddt Excel Worksheet Functions 0 May 21st 08 11:08 AM
Filter or sort a macro result laralea Excel Discussion (Misc queries) 2 August 17th 07 08:26 PM
save filter Beatriz from San Diego, US Excel Worksheet Functions 1 July 29th 06 09:46 PM
save auto filter coconutt Excel Discussion (Misc queries) 1 February 23rd 06 06:24 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"