Absolute Reference

kumara_faith

Well-known Member
Joined
Aug 19, 2006
Messages
955
Office Version
  1. 365
Hi,

I have a budget template as follows:

Excel Workbook
BCDEFGH
2Expense CodeInput Code 2018Input Code 2019Input Code 2020Input Code 2021Input Code 2022Budget 2018
37001250250250250250250
47001350350350350350350
57001120120120120120145
67001360360360360360875
77001653653653653653653
87001150150150150150256
97001231231231231231145
107001254254254254254965
117001254254254254254254
127001547547547547547547
137001587587587587587587
147001521521521521521521
157001154154154154154254
167001545454545454
177001254254254254254254
187001587587587587587587
197001575757575757
207001511511511511511511
Sheet1




I need the cells in yellow in the column Input Code 2018 to 2022 to return the values in the Budget 2018 accordingly across multiple sheets at once

What I am doing right now is I am making the cells in column Input Code 2018 (only the yellow cells) to reference column Budget 2018 and then dragging across from column Input Code 2018 to Input Code 2022 for each row for the yellow cells.

I have about 20 sheets in the same workbook that I need to do exactly the same thing. After referencing the Input Code 2018 (yellow cells) to Budget 2018 column, is there a way to simultaneously change the cells in yellow for Input Code 2018 to absolute referencing simultaneously for all the sheets?

Appreciate all the help.
 
Last edited:

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,224,823
Messages
6,181,183
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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