software

Hello,
Can somebody help me out with the following:

I would like to use a quot;standardquot; 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,
Stephanindirect will not work if the other workbook is closed
--
paul
remove nospam for email addy!
quot;Stephanquot; wrote:

gt; Hello,
gt; Can somebody help me out with the following:
gt;
gt; I would like to use a quot;standardquot; workbook Workbook_1 that when I fill in a
gt; name of another workbook (Workbook_2) in cell A1 and the name of a worksheet
gt; (Sheet1)of that workbook in cell A2, I will get a summary of that worksheet
gt; (for example cells E1, E2 and E3).
gt;
gt; In summary, worksheet_1 shows the following:
gt; A1 = Workbook_2
gt; A2 = Sheet1
gt;
gt; The result should be:
gt; E1 = 50
gt; E2 = 100
gt; E3 = 250
gt;
gt; The moment I change cells A1 and A2 for information of antoher workbook and
gt; worksheet, I cells E1, E2 and E3 change immediately.
gt;
gt; Workbook_2 will be closed (so I will have to use INDIRECT.EXT I would think).
gt;
gt; I hope I explain it well.
gt;
gt; Waiting for your valuable comments,
gt; Stephan
gt;

Paul,
I know but INDIREXT.EXT will do the trick, but I am having difficulties in
setting the formulas right.
Stephan

quot;paulquot; wrote:

gt; indirect will not work if the other workbook is closed
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Stephanquot; wrote:
gt;
gt; gt; Hello,
gt; gt; Can somebody help me out with the following:
gt; gt;
gt; gt; I would like to use a quot;standardquot; workbook Workbook_1 that when I fill in a
gt; gt; name of another workbook (Workbook_2) in cell A1 and the name of a worksheet
gt; gt; (Sheet1)of that workbook in cell A2, I will get a summary of that worksheet
gt; gt; (for example cells E1, E2 and E3).
gt; gt;
gt; gt; In summary, worksheet_1 shows the following:
gt; gt; A1 = Workbook_2
gt; gt; A2 = Sheet1
gt; gt;
gt; gt; The result should be:
gt; gt; E1 = 50
gt; gt; E2 = 100
gt; gt; E3 = 250
gt; gt;
gt; gt; The moment I change cells A1 and A2 for information of antoher workbook and
gt; gt; worksheet, I cells E1, E2 and E3 change immediately.
gt; gt;
gt; gt; Workbook_2 will be closed (so I will have to use INDIRECT.EXT I would think).
gt; gt;
gt; gt; I hope I explain it well.
gt; gt;
gt; gt; Waiting for your valuable comments,
gt; gt; Stephan
gt; gt;

HMMM ,thats a new function???
--
paul
remove nospam for email addy!
quot;Stephanquot; wrote:

gt; Paul,
gt; I know but INDIREXT.EXT will do the trick, but I am having difficulties in
gt; setting the formulas right.
gt; Stephan
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; indirect will not work if the other workbook is closed
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Stephanquot; wrote:
gt; gt;
gt; gt; gt; Hello,
gt; gt; gt; Can somebody help me out with the following:
gt; gt; gt;
gt; gt; gt; I would like to use a quot;standardquot; workbook Workbook_1 that when I fill in a
gt; gt; gt; name of another workbook (Workbook_2) in cell A1 and the name of a worksheet
gt; gt; gt; (Sheet1)of that workbook in cell A2, I will get a summary of that worksheet
gt; gt; gt; (for example cells E1, E2 and E3).
gt; gt; gt;
gt; gt; gt; In summary, worksheet_1 shows the following:
gt; gt; gt; A1 = Workbook_2
gt; gt; gt; A2 = Sheet1
gt; gt; gt;
gt; gt; gt; The result should be:
gt; gt; gt; E1 = 50
gt; gt; gt; E2 = 100
gt; gt; gt; E3 = 250
gt; gt; gt;
gt; gt; gt; The moment I change cells A1 and A2 for information of antoher workbook and
gt; gt; gt; worksheet, I cells E1, E2 and E3 change immediately.
gt; gt; gt;
gt; gt; gt; Workbook_2 will be closed (so I will have to use INDIRECT.EXT I would think).
gt; gt; gt;
gt; gt; gt; I hope I explain it well.
gt; gt; gt;
gt; gt; gt; Waiting for your valuable comments,
gt; gt; gt; Stephan
gt; gt; gt;

Check for details:

longre.free.fr/english/

Stephan

quot;paulquot; wrote:

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