You don't need VBA, just AutoFilter:

In an un-used column enter:

=IF(A2="",1,0) and copy down.

The turn on AutoFilter and display and copy only the 0 cells. For
AutoFilter info see:

http://www.contextures.com/xlautofilter01.html
--
Gary's Student


"brenty" wrote:

I have a column of data with blank cells inbetween some of the information. I
would like to list this column of data on a separate worksheet, with the
blank cells removed. Each blank cell in the column, will have data in other
cells in the same row, so the whole row won't be blank.

For example:

Existing worksheet New Worksheet

a a
b
b c
c d

d

Unfortunately I have no experience of writing macros. Can anyone help at all.

Many thanks