Hi,
I don't know what kind of data you have in your columns, but I assume there
is only data in 1 column. One way to do it would be to concantinate the the
data ie. in cell "A2", =B2&C2&D2&E2&F2&G2&H2. This is simple, but it works.
You could then get rid of the formula, copy & past special-values.

"cdwa" wrote:

I am not a programmer so please bear with me as I learn VBA.

I am trying to bring data scattered across 7 columns (b,c,d,e,f,g,h) into
column( a).

How would I do this. I know that I need to test for the precense of data in
the column, select it and move it, then move to the next row.

Can I use something like;

For i = 1 to 20 ' number of rows
Select Case Data
Case Column 1
range.offset (0,1)= range.offset(i,1)
etc.
End Select
Next i

Thanks