INDIRECT.EXT

S

Stephan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top