copying text from alternate cells

[excel_lent]

Hi,

I need to copy text from cells A2, A4, A6 and so on.

Could someone please give a formula for this?

Thanks,
EL.

 

[Ardus Petus]

Where do you want to copy your data to?

That might be done with formulas, not VBA.
--
AP

"excel_lent" <[email protected]> a
écrit dans le message de
news:[email protected]...

 

[excel_lent]

AP,

I want to copy text from cells A2, A4, A6, etc into cells B1, B2, B3
etc.

Thanks
EL.

 

[Ardus Petus]

In B1 (then copy down):
=INDEX(A:A,ROW()*2)

HTH