View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.newusers
Rookie 1st class Rookie 1st class is offline
external usenet poster
 
Posts: 152
Default Auto Number in Invoice

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