ExcelBanter - Pasting Visible Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pasting Visible Cells (https://www.excelbanter.com/excel-discussion-misc-queries/72368-pasting-visible-cells.html)

LyndieBee

Pasting Visible Cells

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

Dave Peterson

Pasting Visible Cells

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.

LyndieBee wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 12:21 AM.