Are you are saying that your original data is
a1 data b1 blank c1 data d:f1 blank g1 data
and you want it to look like
A B C
a1 c1 g1 on another sheet

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Costello" wrote in message
...
Hello,

could someone help me with using a macro?

I need to use a macro to work along the columns of a spreadsheet (i.e.
select cell A1, copy, paste in another spreadsheet's A1, then select cell
B1
and if not blank, copy and paste in the other spreadsheet's B1 and so on).

I will be using nearly all the columns in the spreadsheet so it's not
feasable to just type in the cells in the macro, hence the need for a
loop.

Any help would be appreciated!!


Thanks