selecting alternative cell in a column and Paste

Hi All,

I am trying to write a macro, where I want to pick up alternative cells in each column from Sheet 1 and then Paste in Sheet 2. Each column starts with end of every year ( 31st Dec 1996 and so on. My data in sheet for each average column (for different years) is like this.

Average
Closing Price 26.47

Stock Return -0.68


I want the value for stock return to be pick up different columns ( for each year) then paste in sheet 2.

Could u plz suggest me how to write a macro for this..?

Regards,
Upananda

A macro, no. But put this formula in B3 and copy down and across:

=INDEX(Sheet1!$1:$20, MATCH($A3,Sheet1!$A:$A,0)+1, MATCH(DATE(Sheet2!B$1,12,31),Sheet1!$1:$1,1))


NOTE: Didn't we just do this same thing here:
http://www.excelforum.com/excel-prog...and-paste.html

It's the same basic formula.

Hi JB,

Thanks again for ur answer.

Regards,
Upananda