Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I save autofilter data
I have a spreadsheet that uses autofilters. I want to apply some filters and
save the Excel spreadsheet with a different name and remove the autofilter. I know I could cut and paste the data, but I'm looking for a better way. |
#2
|
|||
|
|||
Without code there is not a way of moving the data, you might consider
Advanced filter which will move the data to another part of the sheet, you can then delete the original data and save as a new file (not sure that's much shorter). Have you considered using Custom views? This allows you to save various filter settings and simply select the view to change the filter. This way you may only need one file. (Viewcustom views...) Otherwise, I suspect you will need code -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "jbwerner" wrote in message ... I have a spreadsheet that uses autofilters. I want to apply some filters and save the Excel spreadsheet with a different name and remove the autofilter. I know I could cut and paste the data, but I'm looking for a better way. |
#3
|
|||
|
|||
Hi jbwerner
Maybe you like this Add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "jbwerner" wrote in message ... I have a spreadsheet that uses autofilters. I want to apply some filters and save the Excel spreadsheet with a different name and remove the autofilter. I know I could cut and paste the data, but I'm looking for a better way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Autofilter on date fields should refelct the underlying data (rat. | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I save data with different colored fonts in EXCEL 2003? | Excel Discussion (Misc queries) |