Reference another worksheet using a cell
 

I have a main worksheet that pulls data from one of several other
worksheets. I would like to be able to type into cell the name of the
worksheet that i wish to use. Is this possible?

E.g
In cell A1 you type worksheet1.xls
In Cell A3 the Formula ='[WORKSHEET1.xls]Sheet1'!$A$5
If i then change A1 to workseet2.xls i want the formula in A3 to change
to
='[WORKSHEET2.xls]Sheet1'!$A$5

Something like = A3!Sheet1!$A$5 but this doesn't work

thanks in advance


--
Lynxbci3
------------------------------------------------------------------------
Lynxbci3's Profile: http://www.excelforum.com/member.php...o&userid=10377
View this thread: http://www.excelforum.com/showthread...hreadid=480984

Reference another worksheet using a cell
 

Something like the following should work for the formala in cell A3,
although the workbook being referenced needs to be open.

=INDIRECT("'["&a1&"]sheet1'!$a$5")


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=480984