Copying data from 1 worksheet and pasting to another skipping blan

  • Thread starter Thread starter Concertgoer
  • Start date Start date
C

Concertgoer

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
 
Try Data>Filter>Autofilter.

Filter for non-blanks then F5>Special>Visible cells only>OK

Copy and paste to the other sheet.


Gord Dibben MS Excel MVP
 
Back
Top