| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
When calling a different file, can I make the tab equal to a cell?
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| How do I make a file read only unless a password is supplied? | Excel Discussion (Misc queries) | |||
| How to I make a back up file in excel. | Excel Discussion (Misc queries) | |||
| How do I make a backup file of my excel document? | Excel Discussion (Misc queries) | |||
| Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
