| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making a Call to an external sheet using a variable...
Hello All
I am looking for a way to create a reference in my first document that will be able to call to a variable document depending on a value in a set cell. So if the cell in document A is 10 then it will know to call document name10.xls and if the value is 11 then it will call document name11.xls... Anyone have any ideas how this can be done? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading data from another sheet where data is in variable cells | Excel Discussion (Misc queries) | |||
| automatically making a copy of a sheet | Excel Worksheet Functions | |||
| automatically making a copy of a sheet | Excel Worksheet Functions | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Threaded Mode
