+ Reply to Thread
Results 1 to 2 of 2

Create permanent unique ID when another cell is populated

  1. #1
    Registered User
    Join Date
    11-10-2020
    Location
    Worthing
    MS-Off Ver
    2016
    Posts
    8

    Create permanent unique ID when another cell is populated

    Hello

    I need to automatically populate a column of cells (X4 - X3000) with a unique ID (21/001, 21/002, 21/003 etc) based off when another cell has been populated with a date (W4 - W3000).

    The dates in W4 - W3000 will be added out of sequence and I don't want this to affect the unique ID of X4 - X3000.
    Hope I've explained this adequately, an example of the desired affect is printed below, any help would be greatly received.
    Attached Files Attached Files
    Last edited by Cartmel; 11-10-2020 at 11:58 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Create permanent unique ID when another cell is populated

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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] Giving permanent number tags to unique values in a list
    By pcopeland in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2018, 10:31 AM
  2. [SOLVED] Based on two cells data validation list should be populated in third cell with unique vals
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2014, 03:21 PM
  3. Insert permanent Date & Time stamp if & when another cell is populated
    By valentino1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 10:15 AM
  4. [SOLVED] Insert permanent Date & Time stamp if & when another cell is populated
    By David_S_Walker in forum Excel General
    Replies: 6
    Last Post: 03-12-2014, 06:08 AM
  5. VBA to create named range bookmark that links from a given cell when populated
    By penfolda in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-12-2013, 09:33 AM
  6. [SOLVED] Insert permanent Date & Time stamp if & when another cell is populated
    By BASELOO in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2012, 02:27 PM
  7. [SOLVED] How to create permanent Menu
    By moon in forum Excel General
    Replies: 2
    Last Post: 06-26-2006, 12:10 AM

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