Copying long ranges into 2 line ranges short cut

[PhattestChef]

Evening All.
I seek your help in what at first was a simple copy of formulas but has turned into a gigantic time consumer.
I have a range A2:CV250 on Sheet1 that gets populated via a form input, (sales of products in 2 week cycles)
I need to HAVE A FORMULA that links Sheet1!A2:C2 to Sheet2!A7:C7, Then Sheet1!D2:AY2 to Sheet2!H7:BC7, THEN Sheet1!AZ2:CU2 to Sheet2!H3:BC3, then Sheet1!CV2 to Sheet2!BG7, where BG7 is a merged cell of BG7:BG8

Then the links must copy down to A257:BC257 and BG7:BG257

When I try to copy the formulas in Sheet2 from row A7 and A8 downwards, they pick up every second line from Sheet1 eg A2, A4, A6 etc.

Other than entering each formula manually IN COL A, COL H and COL BG and copying accross is there a cleverer way to do this without VBA OR MACROS??
As always any ideas are always welcome
Phattest Chef

 

[Perpa]

P_Chef,
I have a macro solution...I know it's not a formula, but it is very simple to use.
You will probably have to unmerge cells BG7:BG8 before you run the macro, but you can remerge them after you run the macro if they need to be merged.

But before I share it... what are you trying to do with the 'links' per this statement:

'...the links must copy down to A257:BC257 and BG7:BG257'

The Range(A257:BC257) is 1 row and 55 columns
AND
The Range( BG7:BG257) is 251 rows and 1 column

It is not clear what you are trying to do here.
Maybe you can elaborate...AND just exactly what are the 'links' you speak of? Maybe show an example.
Perpa