+ Reply to Thread
Results 1 to 3 of 3

Automatic Serial Numbering in Excel

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Dubai
    MS-Off Ver
    MS Office 2013
    Posts
    11

    Automatic Serial Numbering in Excel

    Hi All,

    I will try an be as clear and specific about my "issue" and what I would like to do. I am dong invoices and quotations in excel. Every quote has a serial number and of course each invoice. I would like to set up so that when a user sets up a new quotation in excel a serial number is generated automatically in the serial number order. For instance => MJ -Quote-201601-001, MJ -Quote-201601-002 etc

    I usually then have a hyperlink from this quote to the invoice which is linked to this quotation.

    Question:

    1. Shall I use some IF formula for generation of automatic sequential numbering or do I need some VBA magic here?

    2. Can the hyperlink be automated somehow so I do not have o manually go and select each invoice from a separate location. For instance if the invoice number would be highlighted oin the quotation sheet, could there be some automated link that updates the hyperlink?

    I know I might not eb entirely clear here, but any suggestion here would be much appreciated.

    Thank you
    Markus

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Automatic Serial Numbering in Excel

    assuming user will enter quotes in cell B2 and A2 needs to have serial numbers then in A2 you can use
    =IF(B2="","","MJ -Quote-201601-"&TEXT(ROW(A1),"000"))

    and drag down
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Automatic Serial Numbering in Excel

    If you will start with second row then
    ="MJ -Quote-201601-00"&ROW()-ROW($A$1)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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. Automatic Ruining Serial Number Against Multiple Reference in Excel
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2015, 04:26 AM
  2. Automatic Numbering in Excel
    By Livid_Enema in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2009, 07:51 AM
  3. Generating Automatic Serial Number in Excel
    By vajeehu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2007, 04:11 PM
  4. [SOLVED] Automatic numbering in excel
    By dshemesh in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-24-2006, 09:55 AM
  5. excel automatic numbering
    By Spice in forum Excel General
    Replies: 4
    Last Post: 04-25-2006, 02:10 PM
  6. [SOLVED] automatic numbering of rows in excel, how to?
    By Don in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM
  7. automatic numbering of rows in excel, how to?
    By Linda C. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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