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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Back
Top