You can use an Advanced Filter to extract the items in column A to a
different sheet. There are instructions he

http://www.contextures.com/xladvfilter01.html#ExtractWs

Start from the sheet where you want the new list to appear. In the
Advanced Filter dialog box, select column A as the List range, and if
you want each item listed only once, check the box for Unique records only.

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html