Pasting Visible Cells

L

LyndieBee

I have a filtered list and I want to copy and paste only the visible cells to
a new worksheet. Help Please!!!???
 
D

Dave Peterson

If you're using xl97+, then just selecting those visible rows and copy|pasting
should be sufficient.

If you're using xl95, then you have to select the range first,
then edit|goto|special|visible cells only

Then copy|paste.
 
Top