Forum Discussion
Formula sheet increment
I have a sheet that takes the total sum from other sheets cell U48. My current formula is =‘001’!U$48. I have to create a totaling sheet that will reference U48 from sheet 001-100. How do I create a...
If you really need to pull in each individual sheet total then you can use INDIRECT():
=INDIRECT("00"&ROW(A1)&"!U$48")
and then drag down
=INDIRECT("00"&ROW(A1)&"!U$48")
and then drag down
mtarler that worked! Thank you. Saved me a ton of time
