Kind of weird how the did that, weirder how to get around it. Easiest is to
hit ctl+G select special, then check the box near the bottom right visible
cells only, then copy your cells and paste it. This is in 03 as i dont have
07 but should be the same. MS ought to give me 07 so i can help with that too
:)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Kerry B" wrote:

In Microsoft 2000, I could filter data and then copy it to a new worksheet
getting only the data showing on the screen. I am now using Enterprise 2007
and am trying to do the same. Everytime I try this, it copies all the data,
not just the data on the screen that excluded the data I have filtered out.
Are there any tricks for being able to do this as easily in Enterprise 2007
as I did in 2000? Any help would be greatly appreciated. Thanks!