Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Auto-Filtered Data (or deleting the rest)
Hi,
I need to either be able to save auto-filtered data (without the rest of the spreadsheet), or delete the un-dsplayed data. The best would be able to filter the data, then be able to save the filtered data into another spreadsheet, go back to the original data, re-filter, then save into a new spreadsheet. Currently I am filtering, cut/paste, save - and it is a bit tedious as I have to do this multiple times a few times a month. Any easy way to do this? Can I make a macro that isn't spreadsheet specific so that I have this function available to me on all spreadsheets? Any help or suggestions would be great. To note - I don't know a thing about macros..... so a step by step process would be greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Auto-Filtered Data (or deleting the rest)
How about reversing the filter--filter to show the rows you want to get rid of.
Then you can delete the visible rows (save the header, though). CH53 wrote: Hi, I need to either be able to save auto-filtered data (without the rest of the spreadsheet), or delete the un-dsplayed data. The best would be able to filter the data, then be able to save the filtered data into another spreadsheet, go back to the original data, re-filter, then save into a new spreadsheet. Currently I am filtering, cut/paste, save - and it is a bit tedious as I have to do this multiple times a few times a month. Any easy way to do this? Can I make a macro that isn't spreadsheet specific so that I have this function available to me on all spreadsheets? Any help or suggestions would be great. To note - I don't know a thing about macros..... so a step by step process would be greatly appreciated. Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Auto-Filtered Data (or deleting the rest)
Thanks for the suggestion - that does work - but is not optimal (as there are
over 3500 other lines to delete). I know that I mentioned deleting in my initial post but now that I am looking into it more - the option I am looking for is to save the filtered data to a new workbook. "Dave Peterson" wrote: How about reversing the filter--filter to show the rows you want to get rid of. Then you can delete the visible rows (save the header, though). CH53 wrote: Hi, I need to either be able to save auto-filtered data (without the rest of the spreadsheet), or delete the un-dsplayed data. The best would be able to filter the data, then be able to save the filtered data into another spreadsheet, go back to the original data, re-filter, then save into a new spreadsheet. Currently I am filtering, cut/paste, save - and it is a bit tedious as I have to do this multiple times a few times a month. Any easy way to do this? Can I make a macro that isn't spreadsheet specific so that I have this function available to me on all spreadsheets? Any help or suggestions would be great. To note - I don't know a thing about macros..... so a step by step process would be greatly appreciated. Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Auto-Filtered Data (or deleting the rest)
Try recording a macro when you
Show all the data filter the data by the fields you like select the visible cells and copy|paste to a new worksheet CH53 wrote: Thanks for the suggestion - that does work - but is not optimal (as there are over 3500 other lines to delete). I know that I mentioned deleting in my initial post but now that I am looking into it more - the option I am looking for is to save the filtered data to a new workbook. "Dave Peterson" wrote: How about reversing the filter--filter to show the rows you want to get rid of. Then you can delete the visible rows (save the header, though). CH53 wrote: Hi, I need to either be able to save auto-filtered data (without the rest of the spreadsheet), or delete the un-dsplayed data. The best would be able to filter the data, then be able to save the filtered data into another spreadsheet, go back to the original data, re-filter, then save into a new spreadsheet. Currently I am filtering, cut/paste, save - and it is a bit tedious as I have to do this multiple times a few times a month. Any easy way to do this? Can I make a macro that isn't spreadsheet specific so that I have this function available to me on all spreadsheets? Any help or suggestions would be great. To note - I don't know a thing about macros..... so a step by step process would be greatly appreciated. Thanks. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Updating Filtered Data on Next Sheet | Excel Discussion (Misc queries) | |||
Deleting filtered out data from a worksheet | Excel Worksheet Functions | |||
Copy auto filtered data | Excel Discussion (Misc queries) | |||
Deleting data in cells while saving formatting & formulas | New Users to Excel | |||
Calculating auto filtered data | Excel Discussion (Misc queries) |