Do you always want the data to flow ONE way? If so, you just need to create a cell-link from one sheet TO the other.
For two spreadsheets in the SAME directory on your hard drive:
- In spreadsheet one, called Book1, enter a value in cell A1 on Sheet1. Save it.
- In spreadsheet two, called Book2, enter the formula =[Book2.xls]Sheet1!$A$1 in any cell and save it.
- Now close both books
- Open just Book2. It should ask if you want update external data, say YES.
Any changes you make in Book1 will flow to Book2.
Now, if the sheets are NOT in the same directory, you need to list the full path in the [ ] like
=[C:\Temp\Book1.xls]Sheet1!$A$1
Also, if you change the names of the sheets in the workbook, make sure you use the right formula...Sheet1 will change to whatever you named your sheet.
Linear Mode
