+ Reply to Thread
Results 1 to 3 of 3

Auto Tracking Number from select cells

  1. #1
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Auto Tracking Number from select cells

    Hi All,

    I have a formula I am using to try create an auto Tacking Number system

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I want the number to appear as the data is logged into "C5"

    The end product I am looking for will be "TS-July14-001", Where "M5" is the given month, "N2" is 2014 so I used the right formula to get 14

    The last bit is where I am having problems, I would like the last number "001" to have a fill series effect.

    Ultimately if this is possible i would then like the fill series to reset to 001 when the month in "M5" changes.

    Hope this makes sense, Can provide an example workbook if needed

    Regards,
    Simon

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Auto Tracking Number from select cells

    hi simon. always good to upload a sample excel file with desired results. maybe:
    =IF(C5>0,CONCATENATE("TS-",M5,RIGHT(N5,2),"-",TEXT(COUNTIFS(M$5:M5,M5,N$5:N5,N5),"000")),"")

  3. #3
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Auto Tracking Number from select cells

    Hi benishiryo,

    Thanks for the quick reply, hardly any need to upload a sample workbook with experts like yourself.

    That formula works perfect, thanks for your help

    Greatly Appreciated, Rep Added

+ 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. Select Row and auto fill cells in another worksheet
    By mcm1009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2011, 05:13 AM
  2. combo box select cells filled auto
    By corchox in forum Excel General
    Replies: 0
    Last Post: 12-22-2010, 02:42 AM
  3. Auto Select Cells
    By Sniper in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2010, 08:04 AM
  4. Replies: 4
    Last Post: 06-25-2006, 02:35 AM
  5. [SOLVED] auto select cells to print
    By Conrad ICR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2005, 12:08 PM

Tags for this Thread

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