+ Reply to Thread
Results 1 to 2 of 2

Excel formula for ascending serial numbers

  1. #1
    Registered User
    Join Date
    03-04-2010
    Location
    somewhere, over the rainbow
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel formula for ascending serial numbers

    Ok - I am new to using excel but my boss wants me to create a formula or macro or print function or something that will do the following:

    She has a one page worksheet with 4 cells. Each cell represents a label for a piece of machinery that we sell. We have hundreds of pieces going out each day. She wants to be able to print many copies of this one page but have the serial numbers ascend automatically. Does that make sense? I hope so....

    So for instance:
    Cell#1 has serial number RAW52634, Cell #2 RAW52635, Cell #3 RAW52636 Cell #4 RAW52637 . So when we print the first copy the numbers will be correct, but she wants the program to know that on copy 2 the serial numbers should be Cell#1 RAW52638, Cell #2 RAW52639, Cell #3 RAW52640 Cell #4 RAW52641 and so on.

    I dont know if this is possible or simple - I don't usually get asked to do these kinds of things. I am just the receptionist....

    Thanks for any help....

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel formula for ascending serial numbers

    This would require a macro, VBA. Is that OK?

    Are the serial numbers always that format? The numeric portion is always the last 5 digits of an 8-character string?

    What are the cell references?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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