G
Guest
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
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