+ 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,147

    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")),"")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  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. [SOLVED] how do i select all the visible cells only when using auto filter
    By shaurabh in forum Excel General
    Replies: 4
    Last Post: 06-25-2006, 02:35 AM
  5. 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