Forum Discussion
michelesabatini
Aug 21, 2020Copper Contributor
excel formula - multiples sheet
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...
excelkanalen
Aug 21, 2020Copper Contributor
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