Links to Multiple Spreadsheets

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking statements between spreadsheets 2
VLookup multiple spreadsheets 2
Reference constant cells in different files from a master workbook 1
Variable Addresses in Links 3
Deleting links to other spreadsheets 2
Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages 1
Significant DELAY to open spreadsheets containing regular links? 6
Paste Link - Cell Comments get lost 2

Top