Hello,
I have an excel file with our work order sheets in it.
I would like to have a button that when pressed either does a save as function, clears the contents of certain cells then increases the work order number by 1 OR
Copies the current workbook into a new one as saves the new one, clears the contents of the original and increases the work order number.
There will be at least 2-3 people working with this file at any one time, so I want to make sure that the original stays clear and it keeping the work order number in sequence whenever a new order is saved.
I hope this makes sense.
I have attached the file as well.
Bookmarks