Paste/Copy Issue

[Kev]

I am trying to copy data from a worksheet that has its
information all side by side to another workwheet that
has a column between each respective destination cell.
eg Sheet1 G10 to Sheet2 D6; Sheet1 H10 to Sheet2 F6;
Sheet1 I10 to Sheet2 H6; Sheet1 J10 to Sheet2 J6 etc.

Is there a means of hiding every 2nd column on Sheet2 so
destination cells will be side by side and copy/paste as
a range?
OR is there a formula/function to achieve this data
transfer?

Appreciate your help...
Kev.

 

[Frank Kabel]

Hi
in sheet2!D6 enter the following formula:
=IF(MOD(COLUMN(),2)=1,"",OFFSET('sheet1'!$G$10,0,INT((COLUMN(A:A)-1)/2)
))
and copy to the right