save filtered results

[Guest]

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?

 

[Guest]

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.

 

[Guest]

If you want to select the visible cells only, select the range of cells to be
copied, press Alt ; on the keyboard (or Edit, Go To, Special, Visible Cells
Only). You can then paste only the visible cells to the required location.

 

[Guest]

I think this link should help you,
http://www.contextures.com/xladvfilter01.html read portions a,b, & c for a
good overview.

 

[Guest]

Thanks, Mark, that's a step in the right direction. Fortunately, the Alt ;
grabs the visible filtered data in the 2 columns I filtered, but,
unfortunately, it also grabs empty rows and columns to the borders of the
spreadsheet, which is more than I need. But it's a start. Thank you.
- Cathy

 

[Guest]

Yes, that helped a lot! Thank you,
-CRH

I think this link should help you,
http://www.contextures.com/xladvfilter01.html read portions a,b, & c for a
good overview.