Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading data from another sheet where data is in variable cells | Excel Discussion (Misc queries) | |||
automatically making a copy of a sheet | Excel Worksheet Functions | |||
automatically making a copy of a sheet | Excel Worksheet Functions | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |