Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autoselection of Spreadsheet for liking
I have a spreadsheet system my group uses to track status of the various
projects upon which we work. This summary spreadsheet is filled with cellular references to "Specific" Individual spreadsheets (as in the XXXXXXX_TSPM_STATUS.XLS shown below) where XXXXXX is the name of a team member. We are preparing to distribute this functionality to other teams (with other names.) I would like to allow the new teams to enter their names in a VLOOKUP table, select the correct spreadsheet name as a cellular function and then reference that selected cell with the name of the individual spreadsheet transfered to a statement like the one below. ='H:\PROJO\Status Reports\[XXXXXXX_TSPM_STATUS.xls]TSPM Status Report'!B4 The referenced spreadsheets will almost always be closed when referenced. Thank you in advance Unca' Chuckie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) |