Copying long ranges into 2 line ranges short cut

PhattestChef

New Member
Joined
Mar 8, 2019
Messages
1
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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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
 
Upvote 0

Forum statistics

Threads
1,224,748
Messages
6,180,721
Members
452,995
Latest member
isldboy

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top