I don't use xl2007 enough to offer any tips.

Sorry.

Chgofan wrote:

For some reason this only works part of teh time. There seems to be no rhyme
or reason as to when I am going to get teh entore spreadsheet or just teh
filtered area I am trying to copy. ANy suggestions as to what I may be doing
wrong.

"Dave Peterson" wrote:

I saw this response in a different forum:

The key here is that if you select just the table (or cells in the same rows
as the table) to copy, then you will get the filtered data.

If you select the filtered cells, plus data outside the table (the row
above/below/both) then you will get the entire list (unfiltered).

You can tell what you are going to get by looking at the "running ants"
selection after pressing Ctrl+C. If you see only one area with the running
ants around the outer perimeter, you are going to get the whole table. If
you see several 'mini-selections' inside a larger bold border, then you will
get the filtered data.

Chgofan wrote:

Help - I just upgraded to Office 2007. For some reason, when I filter data in
one of my worksheets and try to copy the filtered data into a new
spreadsheet, all teh rows in between my filtered data are copied to my new
spreadsheet as well and not just my filtered data. I never had this problem
in 2003. Any suggestions?

Thanks

--

Dave Peterson


--

Dave Peterson