+ Reply to Thread
Results 1 to 3 of 3

Creating 'next' value, based on column entries

  1. #1
    Registered User
    Join Date
    05-22-2016
    Location
    Aldershot
    MS-Off Ver
    2000-2013
    Posts
    0

    Creating 'next' value, based on column entries

    Hi there, just registered on this forum and i'll immediately apologise for the easy answer this probably has....I'm sort of OK with the basics of Excel, but I am being asked to look at getting into VBA and macros now so some baby steps are probably required.

    My issue is that my Company has a list of self generated manufacturing codes separated by a colon. So for example there's a code for a product (D-), where it is mounted on the board (S-) and then a unique 'next' number. THese numbers have been previously created by a Purchasing team. The problem in the past has been that the numbers have been created by 3 or 4 users, and in the past this has created duplication and overwrites (the database in which these details have been added is dire...

    I've been asked to provide a simple method of creating a unique 'next' number based on the two prior parameters.My Purchasing team need a quick way (a VB program even) to quickly add a reference from column A (in a search box), and a reference from Column B (in a search box) and then the resulting box would produce the next number based on the parameters entered!

    So for example, column A is the product, B is the Mount, so A and B equate to a current serial number. If A and B appear again, then its the next number in the sequence. (sorry for the additional columns, I've had to concatenate and unconcatenate to get some of my own formula tests

    C M 1004 C-M-1004 C-M-1004
    C S 1005 C-S-1005 C-S-1005
    C S 1006 C-S-1006 C-S-1006
    C S 1007 C-S-1007 C-S-1007
    C S 1008 C-S-1008 C-S-1008
    A S 1000 A-S-1000 A-S-1000
    A S 1001 A-S-1001 A-S-1001
    A S 1002 A-S-1002 A-S-1002
    A S 1003 A-S-1003 A-S-1003
    A M 1004 A-M-1004 A-M-1004
    A M 1005 A-M-1005 A-M-1005
    A M 1006 A-M-1006 A-M-1006
    R M 1001 R-M-1001 R-M-1001
    R S 1002 R-S-1002 R-S-1002

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello MarkyMark8869,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    04-28-2016
    Location
    Islamabad, Pakistan
    MS-Off Ver
    2007 , 2010 , 2013
    Posts
    5

    Re: Creating 'next' value, based on column entries

    Hey Mark. You should post in the Excel General Forum here, I believe:

    HTML Code: 
    This is the intro forum. Not many folks will be reading a question here

+ 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. [SOLVED] Creating a dynamic array to search for multiple specific entries based on criteria
    By Travisty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-22-2015, 05:23 AM
  2. [SOLVED] Creating a dynamic array to search for specific entries based on multiple criteria
    By Travisty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2015, 12:30 AM
  3. Creating an named range from a column of text entries
    By Matt6037 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2015, 03:16 AM
  4. Replies: 1
    Last Post: 06-12-2014, 10:51 AM
  5. [SOLVED] Creating a macro (or module) to modify a cell's value based on automated entries
    By Julez80s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2012, 01:51 PM
  6. Autofill Column B based on Column A entries
    By cprickett in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-12-2009, 10:23 AM
  7. function to sum a column's entries based on another column
    By brickc1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-20-2009, 08:02 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