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/

"duketter" wrote:

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!