Quote:
Originally Posted by Detoxing
Ok, next question:
Lets say i have the same sheet in two different workbooks. Is there a way to make the sheet in workbook B automatically update when i edit it in workbook A?
|
Yes, you can do that. This is the way I know to do it. May be a more automated solution.
1) save the two files in the place you always want them to live.
2) create reference formulas in workbook b to the corresponding cells in workbook IE (=WorkbookName!A7)
3) make your updates in workbook a. Save.
4) open work b. When it asks you if you want to update, say OK.
As long as you don’t move Workbook A, workbook b should always update when you open it.
You could probably make it happen without opening workbook B with a fancier approach.