Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic WorkBook Linking
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/...ngExternal.zip but can seem to see how it works Any help greatly appreciated Cheer Richar -------- Message sent via www.excelforums.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
dynamic linking worksheets | Excel Discussion (Misc queries) | |||
Linking to another spreadsheet in a dynamic way | Excel Discussion (Misc queries) | |||
dynamic linking | Excel Discussion (Misc queries) | |||
Dynamic Linking | Excel Discussion (Misc queries) |