Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ref to Tab Name
My spreadsheet has a summary tab and 40+ supporting tabs. The summary tab
has two columns: Column A which houses 40 rows of country names and Column B which will have a link to each of the 40+ supporting tabs also possessing country names. Is it possible to use a cell reference in Column B in lui manually linking each tab? With several dozen of these spreadsheets to create I'm looking at automating the links. A B 1 Austria =T(A1)&!$E$10 It is my attempt for Col B to mimic "=Austria!$E$10" and return the numerical amount in E10. Any thoughts? |
#3
|
|||
|
|||
Yes, the INDIRECT command is a way to go however, if the linked file is not
open then I get a #REF! Ideally I would like to find a different way. "Don Guillett" wrote: Have a look in HELP index for INDIRECT -- Don Guillett SalesAid Software "briank" wrote in message ... My spreadsheet has a summary tab and 40+ supporting tabs. The summary tab has two columns: Column A which houses 40 rows of country names and Column B which will have a link to each of the 40+ supporting tabs also possessing country names. Is it possible to use a cell reference in Column B in lui manually linking each tab? With several dozen of these spreadsheets to create I'm looking at automating the links. A B 1 Austria =T(A1)&!$E$10 It is my attempt for Col B to mimic "=Austria!$E$10" and return the numerical amount in E10. Any thoughts? |
#4
|
|||
|
|||
briank wrote...
Yes, the INDIRECT command is a way to go however, if the linked file is not open then I get a #REF! Ideally I would like to find a different way. .... It would have helped if you had mentioned you needed to reference ranges in other workbooks rather than other tabs in your original message. The following link discusses the known alternatives. http://groups-beta.google.com/group/...443753560f0075 (or http://makeashorterlink.com/?F2993260A ). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|