Placing filtered rows into spreadsheet

[Guest]

Question: Once you've applied a filter to a spreadsheet, is there an easy way
to save the filtered results into another workbook (so that the hidden rows
are deleted in the new sheet)? I basically need to create a new file, and I
don't want to jump through the hoops of linking to Access if I don't need to.

Thanks,
Eric

 

[Dave Peterson]

How about just filtering, copying the visible rows and pasting into that
secondary workbook?

 

[Guest]

Duh! Wow, do I feel stupid. As obvious as that sounds, I never tried it
simply because I expected Excel to copy the hidden rows as well. Thanks for
such a simple solution!

Eric

 

[Dave Peterson]

xl95 copies hidden rows in the autofilter range. But xl's behavior changed in
xl97.

But if you ever want to make sure you only have visible cells in the selection
(like in data|subtotals), you can...

Select the range
edit|goto|special|visible cells
copy and paste

There are lots of things under that special button of the edit|goto dialog. You
may want to look at it -- just to know what's there if you need it.