Please someone help!
I have a 2 workbooks in Book1.xlsx cell B2 it says
='C:\Libraries\Documents\[Book2.xlsx]Oct ''09'!$L$96
my thing is that I want instead of saying Oct ''09' I want it to refer to cell A1 (A! contains the name of the tab)
Also Book2.xlsx is closed and I have been told that I cannot use INDIRECT with closed workbooks..... it returns a #REF
is it possible to do this? PLEASE HELP!!
I have a 2 workbooks in Book1.xlsx cell B2 it says
='C:\Libraries\Documents\[Book2.xlsx]Oct ''09'!$L$96
my thing is that I want instead of saying Oct ''09' I want it to refer to cell A1 (A! contains the name of the tab)
Also Book2.xlsx is closed and I have been told that I cannot use INDIRECT with closed workbooks..... it returns a #REF
is it possible to do this? PLEASE HELP!!