Formula to Copy Data from one workbook and paste to every 2nd column in a different workbook

[Sineadd]

Hi All

I am hoping someone may be able to help me with the below

I am trying to figure out a formula that will allow me to take data from 1 spreadsheet and fill into every 2nd column on another

I want to copy data from lets say cell A1:C1 from one sheet and fill into cells A8, C8, E8 on another

Is it possible ?


Thanks Sinead
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl72, width: 64"] [/TD]
[TD="class: xl72, width: 64"][/TD]
[TD="class: xl72, width: 64"][/TD]
[TD="class: xl72, width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

 

[JustynaMK]

Hi Sinead,

Maybe something like that:

=IF(MOD(COLUMN(),2),INDEX(Sheet1!$A$1:$C$1,1,ROUNDUP(COLUMN()/2,0)),"")

Paste some random values into cells A1:C1 (Sheet1), go to another sheet, paste this formula into cell A8 and drag it across.

Cheers,
Justyna