Can someone help me figure this out please. I have created a workbook that has Work Orders sheet that I need multiple people to have access to and also be able to edit/use. There are codes in there that will auto generate work order numbers based on the last used number but when someone opens the file on a different computer it starts at the number last used on that computer and when they save the file it gives them an "Error 400" I also need the files to save a new workbook to a specific folder in dropbox with it being named as a certain cell (G2) value plus the date. I would like for the sheet to adjust the work order number across all the spreadsheets the same. I'm not sure how to code it right and I have been stuck for days. I have attached the workbook in hopes that someone can look at it and help.
Thanks!
Work Order V3.xlsm
Bookmarks