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.