Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cross workbook referencing based on cell input
Hey guys,
I have a 'summary' sheet that references other workbooks and polls data from specific cells on those sheets. Currently I have to 'hard-code' the references to those other workbooks on my summary sheet - is there a way I can use input from a cell to determine which other workbooks are referenced, instead of having to hard-code this into the sheet? That way a user can determine which other sheets are referenced. I'm sure this involves macros, cunning visual basic jiggery pokery, and/or voodoo magic. All replies, even the voodoo ones, are gratefully appreciated! NMG |
#2
|
|||
|
|||
Hi Neal
The indirect function will not work with closed workbooks. But you can run a macro to do this Maybe this will give you some ideas http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Neil Mitchell-Goodson" wrote in message ... Hey guys, I have a 'summary' sheet that references other workbooks and polls data from specific cells on those sheets. Currently I have to 'hard-code' the references to those other workbooks on my summary sheet - is there a way I can use input from a cell to determine which other workbooks are referenced, instead of having to hard-code this into the sheet? That way a user can determine which other sheets are referenced. I'm sure this involves macros, cunning visual basic jiggery pokery, and/or voodoo magic. All replies, even the voodoo ones, are gratefully appreciated! NMG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
what is the format for an input cell? | Excel Discussion (Misc queries) | |||
linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |