Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formulas....
- Thread starter FiGgY132
- Start date
Hi,
There sure is...
Open both WorkBooks, and in the destination WorkBook, type '=' in your desired cell. Then from the Window menu, select your other WorkBook and click on the relevant Cell on the relevant Sheet.
The resulting formula will look something like this;
='C:\[Book1.xls]Sheet1'!$A$1
This is know as linking workbooks. When you open your destination WorkBook in the future, you will be prompted to 'Update Links?', by clicking Yes, your destination workbook will update from the data in the source WorkBook.
Hope this helps.
Leigh Moore
Solutions 4 MS Office Ltd
There sure is...
Open both WorkBooks, and in the destination WorkBook, type '=' in your desired cell. Then from the Window menu, select your other WorkBook and click on the relevant Cell on the relevant Sheet.
The resulting formula will look something like this;
='C:\[Book1.xls]Sheet1'!$A$1
This is know as linking workbooks. When you open your destination WorkBook in the future, you will be prompted to 'Update Links?', by clicking Yes, your destination workbook will update from the data in the source WorkBook.
Hope this helps.
Leigh Moore
Solutions 4 MS Office Ltd
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question