I would like to create a workbook where worksheets are created with identical templates for use to enter new invoice records. When in use, at least one main invoice will be created. If there are going to be additional invoices for the same order or client, I will add it on the next worksheet with the invoice be giving the same number as the main one but with e letter following it such as 252525a, 252525b, etc.... Once I'm done inputting these invoices, I would like to be able to click on a button to save a copy of the entire workbook that contain the invoices created for the same client/order in set of another location/folder and have the data clear out for the next set of invoices to be entered. Thank you for your help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Create multiple invoices on one workbook with one invoice per worksheet then saving the entire workbook.
- Thread starter MikeeRDX
- Start date
