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

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

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

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

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