| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking workbooks based on a variable factor
Hi,
Is it possible to have links to another file based on a variable factor selected in the main sheet? For example, the main file is currently linking to a JuneUK.xls file as I'm displaying June data. If I were to change the main file to show July data (by dropdown box and Indirect formula) is it then possible for the links to realise that they need to be adjusted to link to a JulyUK.xls file? Hope this is clear. Let me know if not. Cheers! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to sum various cells based on rate factor | Excel Worksheet Functions | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| Formula pull factor from chart based on value of diff field? | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Linking WorkBooks Based on Data Entered In One of Them | Excel Discussion (Misc queries) | |||
Threaded Mode
