selecting alternative cell in a column and Paste

[pani_hcu]

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