I have an invoice sheet and when all pertinent information is entered into it I would like a new invoice sheet with the same format to be created in that workbook. At the same time the previous(finished) invoice should be deleted from the workbook and filed away into another workbook specifically for old invoices. Any ideas would be of great help. Attached is the invoice for further clarification.
Hello jrcream,
The attached workbook contains the following macros. Clicking on the "Save Invoice" button will save the current invoice to the workbook for old invoices, Each saved sheet is named "Invoice " and the invoice number. You should change the folder path and file name to what you want to use.
If the folder doesn't exist then the macro will create it. The invoice number is stored locally on your computer and not on the worksheet. This is more secure and prevents the users from easily altering the invoice number. If no invoice number has been assigned, you will be prompted to enter one.
Sincerely,
Please Login or Register to view this content.
Leith Ross
Last edited by Leith Ross; 08-01-2008 at 05:46 AM.
to build upon this idea now I want to be able to open the old invoices to update them and have their changes saved without creating a new invoice. Also I'd like certain cells to be archived(the date of event and pickup) into another worksheet based on the invoice #.
to clarify the above statement:
The code written by Leith only allows one invoice to be saved and if a new invoice is saved it overwrites the previous invoice. I am trying to alter and revise the code to allow an infinite amount of invoices to be saved as well as allowing invoices to be altered and saved. When they are saved the referenced cells in the invoice used in another worksheet should also be updated based upon the invoice #. If anyone can help it will be greatly appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks