+ Reply to Thread
Results 1 to 4 of 4

On an Invoice, how do I put an invoice number on that will change when opened.

  1. #1
    Registered User
    Join Date
    03-10-2014
    Location
    Glasgow Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    On an Invoice, how do I put an invoice number on that will change when opened.

    I am a very basic user

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: On an Invoice, how do I put an invoice number on that will change when opened.

    See if there's anything here that helps:

    http://mcgimpsey.com/excel/udfs/sequentialnums.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    03-10-2014
    Location
    Glasgow Scotland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: On an Invoice, how do I put an invoice number on that will change when opened.

    Thanks to y'all for your help here, as am a very basic user and just learning, i need some time to digest this and even more time to apply. Thanks to you all your time is very much appreciated.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: On an Invoice, how do I put an invoice number on that will change when opened.

    You're welcome!

    Let us know how you make out.

+ 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. Print Invoice by pulling info from database by selecting Invoice Number
    By Swapnil Panchal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 11:21 AM
  2. Saving Invoice where next time I open file the Invoice Number increases by 1
    By domgee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 03:03 PM
  3. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  4. Replies: 1
    Last Post: 03-03-2006, 06:40 AM
  5. [SOLVED] How do I change the invoice number assigned in Invoice template...
    By akress in forum Excel General
    Replies: 1
    Last Post: 02-28-2005, 03:06 PM

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