Home |
Search |
Today's Posts |
#18
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |