ExcelBanter - Links to Multiple Spreadsheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Links to Multiple Spreadsheets (https://www.excelbanter.com/excel-worksheet-functions/91126-links-multiple-spreadsheets.html)

Links to Multiple Spreadsheets

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

Only today!!!
http://nfl-schedule.0moola.com/index.html http://dance-instruction.0catch.com/index.html http://nfl-schedule.0catch.com/nfl-schedule.html [url=http://adjustable-rate-mortgage.0catch.com/adjustable-rate-mortgage.html<badjustable rate mortgage</b[/URL] http://guitar-chord.0catch.com/index.html <A HREF="http://dance-instruction.0catch.com/index.html"<bdance instruction</b</A [url=http://dance-instruction.0catch.com/index.html<bdance instruction</b[/URL] <A HREF="http://nfl-schedule.0moola.com/nfl-schedule.html"<bnfl schedule</b</A [url=http://nfl-schedule.0moola.com/nfl-schedule.html<bnfl schedule</b[/URL] [url=http://guitar-chord.0catch.com/guitar-chord.html<bGuitar chord</b[/URL] <A HREF="http://pregnancy-calendar.0catch.com/pregnancy-calendar.html"<bpregnancy calendar</b</A <A HREF="http://pregnancy-calendar.0catch.com/index.html"<bpregnancy calendar</b</A [url=http://nfl-schedule.0moola.com/index.html<bnfl schedule</b[/URL] <A HREF="http://guitar-chord.0catch.com/guitar-chord.html"<bGuitar chord</b</A [url=http://pregnancy-calendar.0catch.com/index.html<bpregnancy calendar</b[/URL] <A HREF="http://adjustable-rate-mortgage.0catch.com/index.html"<badjustable rate mortgage</b</A [url=http://nfl-schedule.0catch.com/nfl-schedule.html<bnfl schedule</b[/URL] [url=http://dance-instruction.0catch.com/dance-instruction.html<bdance instruction</b[/URL]
http://dance-instruction.0catch.com/index.html http://nfl-schedule.0moola.com/nfl-schedule.html http://pregnancy-calendar.0catch.com/index.html http://nfl-schedule.0catch.com/index.html http://pregnancy-calendar.0catch.com...-calendar.html http://adjustable-rate-mortgage.0catch.com/index.html

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Only today!!!
http://dance-instruction.0catch.com/index.html http://pregnancy-calendar.0catch.com...-calendar.html [url=http://nfl-schedule.0catch.com/nfl-schedule.html<bnfl schedule</b[/URL] [url=http://nfl-schedule.0moola.com/index.html<bnfl schedule</b[/URL] <A HREF="http://adjustable-rate-mortgage.0catch.com/index.html"<badjustable rate mortgage</b</A [url=http://nfl-schedule.0moola.com/nfl-schedule.html<bnfl schedule</b[/URL] <A HREF="http://guitar-chord.0catch.com/index.html"<bGuitar chord</b</A <A HREF="http://guitar-chord.0catch.com/guitar-chord.html"<bGuitar chord</b</A <A HREF="http://nfl-schedule.0catch.com/nfl-schedule.html"<bnfl schedule</b</A http://dance-instruction.0catch.com/...struction.html http://nfl-schedule.0moola.com/index.html http://nfl-schedule.0catch.com/nfl-schedule.html http://pregnancy-calendar.0catch.com/index.html [url=http://dance-instruction.0catch.com/dance-instruction.html<bdance instruction</b[/URL] <A HREF="http://nfl-schedule.0moola.com/nfl-schedule.html"<bnfl schedule</b</A http://guitar-chord.0catch.com/index.html [url=http://nfl-schedule.0catch.com/index.html<bNfl schedule</b[/URL]
http://adjustable-rate-mortgage.0cat...-mortgage.html http://dance-instruction.0catch.com/...struction.html http://dance-instruction.0catch.com/index.html http://nfl-schedule.0moola.com/nfl-schedule.html http://pregnancy-calendar.0catch.com...-calendar.html http://nfl-schedule.0moola.com/index.html http://nfl-schedule.0catch.com/index.html

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Nice site!Check it:

Not bad man! Look what i founf hier!!!!!
bed bath and beyound http://bed-bath-and-beyond-ivan.blogspot.com/ <a href= http://bed-bath-and-beyond-ivan.blogspot.com/ bed bath and beyound</a
http://bed-bath-and-beyond-ivan.blogspot.com/

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com