how do I copy continuous cells to everyother cell

P

plahen

I have 2 worksheets in 1 file. I want to reference information from worksheet
2 into worksheet 1. The problem is that the wroksheet 2 information is in
every cell in a given column (A1,A2,A3,A4, etc...) and the cells that I need
to place the info in is everyother column (A1,A3,A5,etc...). Is there a way
to create a formula that will copy the info in WS 2 and place it in WS1 in
everyother cell?
 
F

Frank Kabel

Hi
try the following in A1 on sheet 1:
=IF(MOD(ROW(),2),OFFSET('sheet2'!$A$1,INT((ROW()-1)/2),0),"")
and copy this down
 
Top