Indirect formula

[Samir]

Hello everyone,

I need to write a formula to obtain values from another
work book. At this moment the formula looks like this:

=[My Book.xls]Test'!B6

The above formula is in another workbook in sheet "My
Sheet". I want to write the formula so the column
reference B is taken from A1 in sheet "My Sheet". This is
because each week the column letter changes for the
report. Any help appreciated.

Regards

Samir

 

[Frank Kabel]

Hi
the following works ONLY if the other workbook is open!:
=INDIRECT("'[My Book.xls]Test'!" & A1 & "6")

 

[Samir]

Frank,

Thanks. This works.

Regards

Samir

-----Original Message-----
Hi
the following works ONLY if the other workbook is open!:
=INDIRECT("'[My Book.xls]Test'!" & A1 & "6")

--
Regards
Frank Kabel
Frankfurt, Germany

Hello everyone,

I need to write a formula to obtain values from another
work book. At this moment the formula looks like this:

=[My Book.xls]Test'!B6

The above formula is in another workbook in sheet "My
Sheet". I want to write the formula so the column
reference B is taken from A1 in sheet "My Sheet". This is
because each week the column letter changes for the
report. Any help appreciated.

Regards

Samir

.