I am having trouble filtering a large dataset and pasting a portion in another sheet in 2007. After filter is on I select a portion of the data including the header row (full columns selected, but not all columns) , and paste this selection into a set place in a new workbook (a few columns in). I keep getting the full dataset pasted as if without the filter on. Any ideas??

The old excel did not give me any problems with this but I am not as familiar with Excel 2007.

Any help is much appreciated!