Results 1 to 2 of 2

Create permanent unique ID when another cell is populated

Threaded View

  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.

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. 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