select every other cell

[deb]

How can I select every other cell in Row B, from row 2 thru row 250?

Thanks

 

[Norie]

deb

The code I posted in the duplicate thread, with the same title as this one, does select every other cell in the column.

 

[Yogi Anand]

The code in the duplicat thread selects every other row and not every other cell.

The code for every other row works great. but I must be able to select the cell to move it. I cannot move the row.

How can I select every other CELL, without replacing the data or deleting the data?

Data looks like this...

Item1
price1
Item2
price2

I need...

Item1 price1
Item2 price2

so if I can select every other cell in the column, i can move them the correct column.


Thanks,

Hi deb:

If I have understood your need correctly, following is one formula based approach ...

Book1
	A	B	C	D	E	F
1	Item1		Item1	Item2	Item3	Item4
2	price1		price1	price2	price3	price4
3	Item2
4	price2
5	Item3
6	price3
7	Item4
8	price4
9
Sheet5

formula in cell C1 is ... =INDEX($A:$A,COLUMNS($A:A)*2-MOD(ROW(),2))

this is then copied to the right and down.

If this approach works for you, you may also optionally convert the formulas in cells C1:F4 to values and then also optionally delete columns A and B.

I hope this helps.