Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to Indirect
I've learned that Indirect only works in referencing another workbook
when that workbook is open. Is there a way to have a list of references to external workbooks that can be selected from a validated list that would then reference a closed workbook? I know how to create the validated list..... Its a matter of finding an alternative to Indirect that would allow me to reference a particular workbooks cell value. For instance Suppose the list was something like [workbook1.xls]worksheet1'!A1 [workbook2.xls]worksheet1'!A1 etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to Indirect
Harlan Grove wrote a UDF called PULL that will retrieve the value from a
closed workbook. You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. wrote: I've learned that Indirect only works in referencing another workbook when that workbook is open. Is there a way to have a list of references to external workbooks that can be selected from a validated list that would then reference a closed workbook? I know how to create the validated list..... Its a matter of finding an alternative to Indirect that would allow me to reference a particular workbooks cell value. For instance Suppose the list was something like [workbook1.xls]worksheet1'!A1 [workbook2.xls]worksheet1'!A1 etc. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT - Strange behavior | Excel Discussion (Misc queries) | |||
Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions |