Aug 21 2020 06:58 AM
Hi all,
is there a formula that always links a cell to a given cell of the previous sheet?
Fo instance I'm creating a lot of sheets on the same files, and every sheet reports a number in cell B3 that is +1 compared to the number shown in the B3 of the previous sheet.
So instead linking manully every single time B3 of sheet 2 with ='sheet1'B3+1, is there a formula to avoid the manual plug in formula?
Thanks
Aug 21 2020 07:20 AM
@michelesabatini without testing I believe the formula below could solve your problem.
=INDIRECT("sheet"&REPLACE(MID(CELL("filename", A1), FIND("]", CELL("filename", A1))+1, 31), "sheet", "")-1&"!B3")+1