Hi,

You can also try this

Suppose the numbers are in range A2:A9. In cell A1, type Numbers. In cell
A12, use the following formula =MOD(ROW(A2:A9),2)=1. Now go to Data
Filter Advanced Filter and select "Copy to another location". In the list
range, refer to range A1:A9. In the criteria rang, refer to range A11A12
and in the copy to box , select D1:D9. Now click on OK.

Please note that this is not a dynamic solution I.e.if any values change in
range A2:A9, the result in D1:D9 will not change - you will have to rerun
the advanced filter.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Yuelin" wrote in message
...
Hi

I have values in a column of cells, A1, A2, A3, A4, A5, A6, A7, A8 and so
on.

Then I only want to pick up the value in A2, A4, A6, A8...., and put them
into column B, i.e. B1, B2, B3, B4....

How to do this

Thanks

Yuelin