need help with something that is prob simple and maybe im just sleep deprived but cant come up with answer
I have approximately 50 of these tables pasted down a sheet. the numbers in the Base and Total tables are a formula based on the numbers in the columns on the left. For example, E4 = 3000 / 1000. The tricky thing is that all the values in the table reference the 1000 number, so I use absolute references for the formula to calculate them. When I copy and paste the tables for the 1000 entry down to the 2350 entry it still references the 1000 bc of the absolute formula. Is there a way to have the tables reference the 1000 but then copy and paste those down to the 2350 table and then reference the 2350?
I have approximately 50 of these tables pasted down a sheet. the numbers in the Base and Total tables are a formula based on the numbers in the columns on the left. For example, E4 = 3000 / 1000. The tricky thing is that all the values in the table reference the 1000 number, so I use absolute references for the formula to calculate them. When I copy and paste the tables for the 1000 entry down to the 2350 entry it still references the 1000 bc of the absolute formula. Is there a way to have the tables reference the 1000 but then copy and paste those down to the 2350 table and then reference the 2350?
Base | Total | |||||||||||
1000 | Year 3 | Year 5 | Year 10 | Year 3 | Year 5 | Year 10 | ||||||
I | II | III | IV | I | II | III | IV | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
Base | Total | |||||||||||
2350 | Year 3 | Year 5 | Year 10 | Year 3 | Year 5 | Year 10 | ||||||
I | II | III | IV | I | II | III | IV | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||||
#REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! |