T
Tim
I would like to create a formula that grabs a value from
another multi-sheet file. The workbooks both contain the
same number of tabs and all the tabs are named the same.
ex. ='F:\Tim\[All Sales]Region1'!E3
Region1 or any region, will be named in a particular cell.
A1 = Region1
So I would like the formula to read:
='F:\Tim\[All Sales]"A3"'!E3
so cell A3 defines the external sheet name. I would also
like the cell reference (E3)to be dynamic so I can drag
the formula.
Thanks in advance
another multi-sheet file. The workbooks both contain the
same number of tabs and all the tabs are named the same.
ex. ='F:\Tim\[All Sales]Region1'!E3
Region1 or any region, will be named in a particular cell.
A1 = Region1
So I would like the formula to read:
='F:\Tim\[All Sales]"A3"'!E3
so cell A3 defines the external sheet name. I would also
like the cell reference (E3)to be dynamic so I can drag
the formula.
Thanks in advance