cell reference to another file
 

Hey,
i am working on updating a spreadsheet i am using, and would liek it to
update with invoice no's such as:-
='S:\2005-2006 Sales\Invoices\[17142.xls]Sheet1'!$B$11

where 17142.xls is the other spreadsheet i want to get teh data out
of.
this is fine, however i want to have a cell "A3"on teh current
worksheet to tell the formula which invoice sheet to get teh value
from.
this is teh formula i hav etried:-

='S:\2005-2006 Sales\Invoices\[" & A3 & ".xls]Sheet1'!$B$11

does anyone have any ideas on how to put a relative cell reference in a
file path?

any ideas would be greatly appreciated.

Thanks
Tim :confused:


--
bubbles1611
------------------------------------------------------------------------
bubbles1611's Profile: http://www.excelforum.com/member.php...o&userid=27423
View this thread: http://www.excelforum.com/showthread...hreadid=525925