I have 4 workbooks which each contain a sales log. 1 is a Master Log and 3 are maintained by separate users. I am looking for the easiest way to update the Master Log with the data from the other 3 workbooks that is fast, user friendly and avoids data being corrupted by the users.
Open to suggestions other than the following, however if this is an appropriate solution would appreciate the help in writing the VBA...
Attached is a sample of how the data is ordered -- I have considered using named ranges and running a macro in the Master Log that would:-
- Open Sales Person 1 Workbook
- Copy Range1
- Paste Range1 data (values only) in Master Log Range1
- Close Sales Person 1 Workbook
- Repeat for Sales Person 2 and 3 Workbook
- Save and close Master Log
Will also need to consider ensuring each worksheet is sorted. All sheets are named the same in each workbook.
Thanks in advance.
Master Log.xlsx
Sales Person 1.xlsx
Sales Person 2.xlsx
Sales Person 3.xlsx
Bookmarks