Home |
Search |
Today's Posts |
#19
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto Number in Invoice
Would you like me to go back through the method you were investigating and
check anything out? I suspect that the way you describe it as working may be by intent - create a new file from the template, set up what ever individual info is needed to get started, close it down and then next time you open it, it starts incrementing? That kind of operation would be ok for a setup where you were just printing the created invoice, filling in unique information each time to print out a new one. The auto-incrementing of it on each open would be troublesome if you were also trying to keep copies of the invoices as part of your workbook. "Rookie 1st class" wrote: J, Liz & Pam My method works if not a template or you reopen the template (negates purpose of template). You must open the document for it to add a 1. Opening a copy (<File, <New) of a Template does NOT open the original document. Therefore it never increments. I suspect that is also true of McGimpsey link. Dave HELP!!! Lou "JLatham" wrote: Grab the .zip file I uploaded for Pammi J he http://www.microsoft.com/office/comm...c-bd3aeb241c30 that will give you one way to do it. You can change the reference to cell E5 in the code to whatever cell on a worksheet you'd like the Invoice number to show up in. By revising the InvoiceNumber.txt file, you can even set your own starting number for your first invoice. "lizard1socal" wrote: JLantham or somebody.......... Could somebody ,anbody answer my last post , por favor? just want to know how to auto number an invoice !!?? lizard1socal -- lizard1socal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to do a auto number generater | Excel Worksheet Functions | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Auto Number | Excel Discussion (Misc queries) | |||
Auto number invoices in Excel | Excel Worksheet Functions | |||
assign auto number and auto date | Excel Discussion (Misc queries) |