Suppose I have column A a list of sheet's name (those sheet's name exist in that workbook), such that:
CELL A1 : apple
What I want is CELL B1 links to the sheet named in CELL A1: ='apple'!C3 ,
Is there a quicker method instead of editing each formula if I have a lot of sheet's name in column A...
Thanks for all your help
CELL A1 : apple
What I want is CELL B1 links to the sheet named in CELL A1: ='apple'!C3 ,
Is there a quicker method instead of editing each formula if I have a lot of sheet's name in column A...
Thanks for all your help