Making a Call to an external sheet using a variable...
 

Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!

Making a Call to an external sheet using a variable...
 

try this =INDIRECT("[Name"&A1&"]Sheet!A1")
the NameNN file must be open
If you want to work with closed files Laurent Longre has an addin
(morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!

Making a Call to an external sheet using a variable...
 

So in using the Indirect function ... would it be possible to make a
call to a document using this type of code?

=IF(Attendence!B6="", "", '[Mail ExportXXX.xls]Sheet1'!$H4)

Where the xxx is a variable number that will change per a value placed
somewhere else in the sheet?





Bernard Liengme wrote:
try this =INDIRECT("[Name"&A1&"]Sheet!A1")
the NameNN file must be open
If you want to work with closed files Laurent Longre has an addin
(morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!