| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to create new invoice
Works perfectly. Thanks very much :}
"jatman" wrote in message ... somewhere on the sheet is where you have your current invoice number, let's just say K8 is where you have your invoice number. next, somewhere in your macro, you need to add the following mycount = Range("K8") + 1 Range("K8") = mycount hope that helps, jatman. "MB" wrote: Hi, I would like to create a macro which clears the contents of selected cells, creates a new invoice number by adding 1 to the previous number then saves the document. I am OK with the clearing cells and saving worksheet part of the macro but I am not sure how to add the number to the invoice. Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Create a Percentage Discount in Invoice | Excel Discussion (Misc queries) | |||
| how do I create invoice with fillins using again? | New Users to Excel | |||
| how do I create an invoice from a spreadsheet | New Users to Excel | |||
| i need to create an invoice that will flag up when not paid | Excel Discussion (Misc queries) | |||
| How do I create an invoice so every time I need a new one a new i. | Excel Worksheet Functions | |||
![MB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
