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

Similar Threads

Autoselection of Spreadsheet for liking 0
Linking statements between spreadsheets 2
Reference constant cells in different files from a master workbook 1
Embedded spreadsheet 0
Variable Addresses in Links 3
Can a spreadsheet recognize the current directory it is in? 2
Multiple Challenging Excel needs.... 0
Reference a file by concatenating cell variables 13

Top