Links to Multiple Spreadsheets

  • Thread starter Spreadsheet Linking Flexibility
  • Start date
S

Spreadsheet Linking Flexibility

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

Top