Copy linked cells without incrementing rows

hungledink

Board Regular
Joined
Feb 20, 2012
Messages
88
Office Version
  1. 365
I have a sheet that has a tab for each month and a summary tab. The first 6 rows of each of the month tabs have data in up to columns AA.
In the summary tab, I want to have rows 1-6 linked to rows 1-6 in the January tab.
Then rows 8-13 linked to rows 1-6 in the February tab, and then so on down the sheet for the whole 12 months.

I’ve linked the rows for January into the summary tab and was going to copy those 6 rows, paste them into rows 8-13 and then do a find and replace substituting January for February. I intended to use this method to populate the summary.

When I paste rows 1-6 into 8-13 however excel incrementaly increases the rows. Is there a way to stop that? I know I could manually link each cell but I’m interested to know if the other way is possible.

Hope that makes sense.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
If you put "$" in front of the cell reference it will lock the reference:

Change A1 -> $A$1
Change A1:C100 -> $A$1:$C$100

Then drag down the formula and those reference will not change.
 
Upvote 0
I thought of that but there’s quite a lot of cells to manually change unless there’s a way to batch change them?
 
Upvote 0
Depending on your formula you may be able to fix the first one and copy accros

you can highlight the cell reference and use F4 to cycle though.

Highlight S1:S17
=sum(S1:S17)

press F4 and it becomes both absolute reverences, neither the column or row change.
=SUM($S$1:$S$17)

press F4 again and now only the rows are locked the column will change
=SUM(S$1:S$17)

F4 again and only the columns are locked the rows will change.
=SUM($S1:$S17)

F4 again and you are back to
=SUM(S1:S17)
 
Upvote 0

Forum statistics

Threads
1,213,507
Messages
6,114,029
Members
448,543
Latest member
MartinLarkin

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