When calling a different file, can I make the tab equal to a cell?

[Guest]

Imagine two files, Book1.xls and Book2.xls. Each file has tabs labeled
1,2,3. When making cell A1 in Book1 equal to cell A1 in Book2, it will look
like this
=[Book2]1!$A$1. Is there any way to make the call for the tab, in this case
the 1 after the [Book2] be a reference to a cell, say A2, in Book1? (I am
using office 2003)

 

[Ed Ferrero]

Hi thebigd08,

Use =INDIRECT(ADDRESS(A3,A4,,,"["&A1&"]"&A2))

Where A1 = Workbook name
A2 = Sheet Name
A3 = row no
A4 = column no

Ed Ferrero
http://edferrero.m6.net