Hello again,

I am attempting to start some code that is beyond my skill level. I have been searching around and I started to realize that I about to go into information analysis paralysis.


Please help with some code if you can;

I have a workbook located here C:\Users\nvandyken\data.xmls

I want to have a Master workbook located here N:\Users\nvandyken\Masterdata.xmls

The 'masterdata.xmls.' would update automatically when the 'data.xmls' workbook updates information being entered into worksheets via userforms within data.xmls
- Currently the 'data.xmls' file updates and saves every time the user completes one of the userforms

The ultimate goal would be that this also happens to the Master workbook with/without being open; is this possible?

Basically all I know at this point is that once an event happens I need a module of code that will transfer the data to the master workbook.

Thanks in advance for assistance!

-Nick