|
Posted to microsoft.public.excel.misc
|
|
|
INDIRECT.EXT
Check for details:
http://longre.free.fr/english/
Stephan
"paul" wrote:
HMMM ,thats a new function???
--
paul
remove nospam for email addy!
"Stephan" wrote:
Paul,
I know but INDIREXT.EXT will do the trick, but I am having difficulties in
setting the formulas right.
Stephan
"paul" wrote:
indirect will not work if the other workbook is closed
--
paul
remove nospam for email addy!
"Stephan" wrote:
Hello,
Can somebody help me out with the following:
I would like to use a "standard" workbook Workbook_1 that when I fill in a
name of another workbook (Workbook_2) in cell A1 and the name of a worksheet
(Sheet1)of that workbook in cell A2, I will get a summary of that worksheet
(for example cells E1, E2 and E3).
In summary, worksheet_1 shows the following:
A1 = Workbook_2
A2 = Sheet1
The result should be:
E1 = 50
E2 = 100
E3 = 250
The moment I change cells A1 and A2 for information of antoher workbook and
worksheet, I cells E1, E2 and E3 change immediately.
Workbook_2 will be closed (so I will have to use INDIRECT.EXT I would think).
I hope I explain it well.
Waiting for your valuable comments,
Stephan
|