Hello All,
I have a number of wookbooks... Let's call them Workbook 1, Workbook 2, Workbook 3 and workbook 4...
Data I enter into Workbook 1 changes the results in Workbook 2 and 3... and Workbook 4 Looks at data in Workbook 1,2 and 3.
Whenever I need to look at workbook 4 I am forced to open workbook 1 (save and close), open workbook 2 (save and close) and open workbook 3 (save and close) to ensure I have the most upto date information.
Is there a way to automatically up date the information in workbooks 1,2 and 3 without physically opening and saving the books? Either macro, application, addon (I have no idea what VBA is)...?
In reality I have 35 workbooks in total that I need to open and close on a weekly basis and am desperate for a easier solution.
Thanks in advance!
Bookmarks