Results 1 to 2 of 2

How can I auto increment a uniq row index with a set prefix?

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2018
    Location
    London
    MS-Off Ver
    2016 for Mac
    Posts
    1

    Question How can I auto increment a uniq row index with a set prefix?

    Hi Excel Forum'ers!

    This is my first post so here goes...

    I have a spreadsheet which i use as a sequential job task sheet. Each row has a unique job reference e.g. JOB01.
    Each job reference may also have subtasks e.g. JOB01.01, JOB01.02 etc

    Is there a clever way (without using VB - as Im not familiar with how to use it and put such a fix in place) to do the following automatically or using a shortcut key(s):

    1. Each time I add a row under a job reference, it auto-populates the sub-task with the correct job reference. So if I create 5 rows under JOB01, it'll populate them with JOB01.01, JOB01.02, JOB01.03 ...JOB01.05 ?

    2. Add or delete rows where the job reference number automatically adjusts to keep each job sequential

    Thank you

    Shabs
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Increment A1 by 1, until B1(=index function of A1*X) becomes >1
    By M_jordan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2017, 07:23 PM
  2. [SOLVED] Auto Increment ID
    By marcusduton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2015, 08:27 PM
  3. Auto ID based on Prefix and suffix
    By RSK88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2014, 09:35 AM
  4. auto increment of column index in vlookup
    By rumi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2014, 10:21 AM
  5. Macro to add prefix and increment?
    By jeff p in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2013, 08:58 PM
  6. Auto increment ID
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2012, 06:32 AM
  7. [SOLVED] DP Auto increment
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2006, 07:40 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