kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 955
- Office Version
- 365
Hi,
I have a budget template as follows:
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.
I have a budget template as follows:
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
2 | Expense Code | Input Code 2018 | Input Code 2019 | Input Code 2020 | Input Code 2021 | Input Code 2022 | Budget 2018 | ||
3 | 7001 | 250 | 250 | 250 | 250 | 250 | 250 | ||
4 | 7001 | 350 | 350 | 350 | 350 | 350 | 350 | ||
5 | 7001 | 120 | 120 | 120 | 120 | 120 | 145 | ||
6 | 7001 | 360 | 360 | 360 | 360 | 360 | 875 | ||
7 | 7001 | 653 | 653 | 653 | 653 | 653 | 653 | ||
8 | 7001 | 150 | 150 | 150 | 150 | 150 | 256 | ||
9 | 7001 | 231 | 231 | 231 | 231 | 231 | 145 | ||
10 | 7001 | 254 | 254 | 254 | 254 | 254 | 965 | ||
11 | 7001 | 254 | 254 | 254 | 254 | 254 | 254 | ||
12 | 7001 | 547 | 547 | 547 | 547 | 547 | 547 | ||
13 | 7001 | 587 | 587 | 587 | 587 | 587 | 587 | ||
14 | 7001 | 521 | 521 | 521 | 521 | 521 | 521 | ||
15 | 7001 | 154 | 154 | 154 | 154 | 154 | 254 | ||
16 | 7001 | 54 | 54 | 54 | 54 | 54 | 54 | ||
17 | 7001 | 254 | 254 | 254 | 254 | 254 | 254 | ||
18 | 7001 | 587 | 587 | 587 | 587 | 587 | 587 | ||
19 | 7001 | 57 | 57 | 57 | 57 | 57 | 57 | ||
20 | 7001 | 511 | 511 | 511 | 511 | 511 | 511 | ||
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: