Dynamic WorkBook Linking

[Richard - ExcelForums.com]

Hello

Apologies if this has been asked before but I searhced and didnt fin
anything so here goes

I have 52 workbooks named 1.xls -> 52.xls they are schedules fo
inbound operations booking delivereis in and out of the warehous
etc

I I want to have a file named output.xls that allows me to select an
4 sequential workbooks i.e. 3.xls - 6.xls and produce graphs based o
those specific workbooks

Is it possible to have a cell that when a number is entered it form
the link. I think it should be simple as the name of the bokos ar
controlled but i cant seem to be able to do it

I've looked a
http://www.ozgrid.com/FreeDownloads/ChangingExternal.zip but can
seem to see how it works

Any help greatly appreciated

Cheer
Richar

 

[Tom Ogilvy]

If the workbooks are open, you can use the Indirect worksheet function.

If not, you can use a macro to build the hardcoded formulas to retrieve the
values into the cells for graphing.