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