Auto Filter question

  • Thread starter Thread starter Michael Raphael
  • Start date Start date
M

Michael Raphael

I have a list of 20 items that I want to use Auto Filter to determine the top 3 and bottom 3 scores, with ties. I find that Auto Filter is perfect for it.

My question is if anyone knows if there is a way to have the Auto Filter function results be copied to another location?

I've tried to use the Advanced Auto Filter and copy but so far it will only copy the entire list as it does not filter first.

Any suggestions or ideas.

Thanks,

Mike Raphael
 
Hi,

You must be doing something wrong there, otherwise this method of
copying the output of the Auto Filter is correct

Please do it once more

Thanks
Shail
 
Hi Mike

You can do this to copy the filter range to new sheet

Copy the filter result
1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Ctrl c or Edit>Copy
4) Insert>Worksheet
5) Ctrl v or Edit>Paste
6) Select the sheet with the filter
7) Press Esc
8) Press Alt d f f or Data>Filter>AutoFilter to turn off AutoFilter






--
Regards Ron de Bruin
http://www.rondebruin.nl




I have a list of 20 items that I want to use Auto Filter to determine the top 3 and bottom 3 scores, with ties. I find that Auto Filter is perfect for it.

My question is if anyone knows if there is a way to have the Auto Filter function results be copied to another location?

I've tried to use the Advanced Auto Filter and copy but so far it will only copy the entire list as it does not filter first.

Any suggestions or ideas.

Thanks,

Mike Raphael
 
Hi Ron:

Thanks for the details.

I did that, copying the results after filtering. That works fine.

I was trying to learn if it could be done in one step!!!!
Not a problem doing two small steps.

Hi Mike

You can do this to copy the filter range to new sheet

Copy the filter result
1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Ctrl c or Edit>Copy
4) Insert>Worksheet
5) Ctrl v or Edit>Paste
6) Select the sheet with the filter
7) Press Esc
8) Press Alt d f f or Data>Filter>AutoFilter to turn off AutoFilter






--
Regards Ron de Bruin
http://www.rondebruin.nl




I have a list of 20 items that I want to use Auto Filter to determine the top 3 and bottom 3 scores, with ties. I find that Auto Filter is perfect for it.

My question is if anyone knows if there is a way to have the Auto Filter function results be copied to another location?

I've tried to use the Advanced Auto Filter and copy but so far it will only copy the entire list as it does not filter first.

Any suggestions or ideas.

Thanks,

Mike Raphael
 
Back
Top