I've been trying to build a workbook for my company to use to track sales.
The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their own info. This workbook uses a userform to submit data, which pulls info from a sheet in the workbook to autofill based on brand of device sold.
I want to be able to update this information on a network drive, and have the workbook updated automatically each time it is opened.
I've been able to do this for an individual range, with no problem.
I want to be able to do this for a full worksheet, so I can define additional ranges as needed and have it populated to users without need for individual updating.
Basically, there are 2 processed that need to be done, the first process is already taken care of, but I'll show you why I need to copy multiple ranges
-Userform automatically populates multiple models based on Sheet2.Range("Brand")
-Populates based on Sheet2.Range("Brand2")
Second process is
-Open Local Workbook
-Sheet2 = NetworkLocation/Workbook/Sheet2
-Userform populates with additional data for Brand3
Is this possible, and could you advise on how to proceed?