Quote:
Originally Posted by duncan_idaho
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.
|
That’s how I know too. If possible I keep all the tabs in one workbook if they use common datasets. I have some giant bastard spreadsheets but that’s my goal.