Hi,

One simply way;

For i=2 to 100 step 2
Cells(i,"C")=Cells(i,"A")
Next i

will move (put) data from A to C for rows 2 to 100 incrementing by 2

HTH

" wrote:

I'm trying to select every other row of data (2,4,6,8, etc) and move
these to a new column. What is the simplest and quickest way of doing
this?