select rows of data & move to new column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ddirks@pcmhc.com - 21 Feb 2006 16:48 GMT

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?

Reply to this Message

Toppers - 21 Feb 2006 17:04 GMT

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

> 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?

Reply to this Message

Dave Peterson - 21 Feb 2006 17:04 GMT

I use an additional column.

I put A in row 1 and B in row 2
I select the cells in x1:X2 (say)
and then copy down as far as I need

Then I apply data|filter|autofilter
show only the A's (or show only the B's) and
copy the visible rows
and paste to the new worksheet.

> 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?

Signature

Dave Peterson

Reply to this Message