I have the same question, but I can tell you what works for me now.

On the filtered page, using the mouse, I can 'right click' and grab all the
lines. By using the mouse, it conveniently does not copy "all" of the data;
it only grabs the lines that the filter revealed.

Unfortunately, if I use any keyboard shortcut and/or macro to grab that
area, it gets all of the data. So I'm stuck picking up the lines manually
and transferring them manually to a separate spreadsheet.

My end goal is to graph just the filtered data. Graphing has the same
problem of picking up all 100 rows in the range (for example), instead of
just the 47 rows (for example) that the filter will display.

I have to use the 'cut' and 'paste' to transfer the 47 rows to a different
spreadsheet so that I can incorporate them into a graph whose range is that
set of rows on the new spreadsheet.


"bookworm" wrote:

Once I do simple auto filtering in a file, I want to have the ability to save
only the filtered results in another worksheet. Or, I want a new worksheet to
display only results of specific filtering from another worksheet. Is there a
simple way to do this?