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...

=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...

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...

Hey again,

I can only get the INDIRECT to work once.. I need to use the formula for
many cells, each with a different filename (thats what the D4 does as the
value increase for each row and thus liks a different worksheet)..

When I try to use the INDIRECT formula on several rows, only the first one
works. The rest of them only return with a 0 value...

Help!

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...