ExcelBanter - Can I copy data from only the visible rows in Excel?

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

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

- - Can I copy data from only the visible rows in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/49446-can-i-copy-data-only-visible-rows-excel.html)

Sarah

Can I copy data from only the visible rows in Excel?

I want to select rows from a worksheet with some rows hidden, copy, and paste
only the contents from the rows which are visible. How is this accopmplished?

Gord Dibben

Sarah

F5SpecialVisible cells onlyOK

Gord Dibben Excel MVP

On Sat, 8 Oct 2005 12:49:03 -0700, "Sarah"
wrote:

I want to select rows from a worksheet with some rows hidden, copy, and paste
only the contents from the rows which are visible. How is this accopmplished?

All times are GMT +1. The time now is 09:41 AM.