I have an app in which a certain subset of data can actually be used. I
have no problem in determining which data has in fact been used, but I
want a VBA routine that can look through a range (in which the used
data appears) and copy them to consecutive cells (with no blanks in
between). An example would be an itemized list, where only the used
item appear.

Eg. Initial column data Wanted data presentation
Blank Test 1
Test 1 Test 2
Blank Test 3
Blank
Test 2
Test 3
Blank

Hope this is clear. Any help would be appriciated.

Simon