# Copying long ranges into 2 line ranges short cut

#### PhattestChef

##### New Member
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

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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

Replies
3
Views
377
Replies
13
Views
1K
Replies
0
Views
3K
Replies
2
Views
546
Replies
4
Views
552

1,203,487
Messages
6,055,713
Members
444,810
Latest member
ExcelMuch

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back