Saving Auto-Filtered Data (or deleting the rest)

[CH53]

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]

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]

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]

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