Excel copy only visible rows from autofilter

[duketter]

Excel 2007 - This was working in a different spreadsheet, however in this new
spreadsheet I am performing a filter using the autofilter function. Then I
only want to copy and paste what was filtered into a new worksheet in the
workbook. However when I copy and paste it pastes every row, even if it
wasn't filtered. I only want to paste the filtered rows. Any ideas?

Thanks!

 

[Dave Peterson]

Deleting or modifying rows that are above and below a hidden row in a filtered
Excel 2007 worksheet also deletes or modifies the hidden row
http://support.microsoft.com/kb/928974/en-us

But if you want to be careful, you should be able to select your range, then hit
F5 and select visible cells only.

Watch what happens to the selection.

You should be able to see the difference by the marquee (dancing ants)
surrounding the selected areas.

 

[drugrep]

Massive error in Excel 2007, they have a hotfix for it, which should be a
Critical Update. The single biggest programming error I've seen in Excel.
Get the hotfix, it will correct the problem. And Microsoft, please make this
a update, not hotfix, too many people pulling their hair out over this.

http://support.microsoft.com/kb/948944/