+ Reply to Thread
Results 1 to 2 of 2

Invoice Numbering

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    Grande Prairie, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    1

    Invoice Numbering

    I have read through several other posts on invoice numbering and can not get mine to increase upon either an open/save. What do I need to do in order to have the invoice number increase on each invoice template at the same time? I have no experience with the VBE portion of Excel. Please can anyone shed some insight into this?

    2013 Reed E-Ticket 1.1.xlsx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: Invoice Numbering

    John McGimpsey shows two ways to do this on his website, one using the Registry to hold the latest number and the other using a text file. Available here:

    http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. invoice numbering
    By Deborah J Doyle in forum Excel General
    Replies: 1
    Last Post: 06-21-2006, 08:45 PM
  2. Invoice Numbering
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 36
    Last Post: 09-07-2005, 12:05 AM
  3. Invoice Numbering
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 09:05 AM
  4. Invoice Numbering
    By thecashman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Invoice Numbering
    By thecashman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1