Ref to Tab Name

[briank]

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?

 

[Don Guillett]

Have a look in HELP index for INDIRECT

 

[briank]

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.

 

[Harlan Grove]

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/microsoft.public.excel.worksheet.functions/msg/ac443753560f0075

(or http://makeashorterlink.com/?F2993260A ).