Copying data from 1 worksheet and pasting to another skipping blan
I currently have 4 rows of data that I have an If then statement which
creates data, with empty cells between them. I am looking for a way to paste that info into another worksheet in the same workbook, however I want it to list the item s one after another, and not paste the blanks. Please hep Thanks so muh |
Copying data from 1 worksheet and pasting to another skipping blan
Try DataFilterAutofilter.
Filter for non-blanks then F5SpecialVisible cells onlyOK Copy and paste to the other sheet. Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 16:10:01 -0700, Concertgoer wrote: I currently have 4 rows of data that I have an If then statement which creates data, with empty cells between them. I am looking for a way to paste that info into another worksheet in the same workbook, however I want it to list the item s one after another, and not paste the blanks. Please hep Thanks so muh |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com