J
jose
Hello guys,
is it possible to get a behaviour like this in Excel?
A1 contains a text value ='C:\[file.xls]List1'!D51 (not a formula!)
A2 contains a reference to A1 so that it actually displays D51 in
external file.xls
I thought INDIRECT would be my choice but it does not work with
external files.
Any ideas?
Cheers,
-- joe
is it possible to get a behaviour like this in Excel?
A1 contains a text value ='C:\[file.xls]List1'!D51 (not a formula!)
A2 contains a reference to A1 so that it actually displays D51 in
external file.xls
I thought INDIRECT would be my choice but it does not work with
external files.
Any ideas?
Cheers,
-- joe