ExcelBanter - View Single Post

Thanks a lot Bob!

Bob Umlas skrev:

=INDIRECT("'[Manager0"&D4&".xls]1A'!D4:D22")
"Frode Hjoennevaag" <Frode wrote in
message ...
I need to create a filename based on the value in a cell for reference to
another worksheet. Is there any way I can do this with a formula?

='[Manager0"D4".xls]1A'!D4:D22

D4 contains the value I want into the filename and the stuff outside the
brackets is a reference within the ManagerXX.xls document..

If D4=3, the formula should get the referenced cells at the Manager03.xls
worksheet...