+ Reply to Thread
Results 1 to 2 of 2

How to create a list that dynamically updates based on other selections

  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    Wichita, KS
    MS-Off Ver
    2007
    Posts
    5

    How to create a list that dynamically updates based on other selections

    Hi, I'm trying to create a "top twenty" priority list for each of the jobs in column B below.
    I would like to create a data validation rule that allows a user to assign a number 1-20 in column A for any of the jobs A-Z in column B, but I don't want the user to be able to assign the same priority to more than one job.
    And after the user reassigns the priorities I want to be able to re-sort the jobs in order of priority.
    Is this doable?
    Thanks,
    -Dan

    PRIORITY JOB
    1 JOB-A
    2 JOB-B
    3 JOB-C
    4 JOB-D
    5 JOB-E
    6 JOB-F
    7 JOB-G
    8 JOB-H
    9 JOB-I
    10 JOB-J
    11 JOB-K
    12 JOB-L
    13 JOB-M
    14 JOB-N
    15 JOB-O
    16 JOB-P
    17 JOB-Q
    18 JOB-R
    19 JOB-S
    20 JOB-T
    JOB-U
    JOB-V
    JOB-W
    JOB-X
    JOB-Y
    JOB-Z

  2. #2
    Registered User
    Join Date
    02-18-2015
    Location
    Wichita, KS
    MS-Off Ver
    2007
    Posts
    5

    Re: How to create a list that dynamically updates based on other selections

    That table didn't quite post the way I had hoped. Please see attachment.
    Thanks,
    -Dan
    Attached Files Attached Files

+ 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] create new list from drop down list selections
    By rod642 in forum Excel General
    Replies: 6
    Last Post: 10-03-2014, 10:39 AM
  2. [SOLVED] Conditional Formatting of List based on selections from Dropdown list
    By FoxyPinkChick in forum Excel General
    Replies: 4
    Last Post: 05-31-2013, 03:32 AM
  3. Replies: 5
    Last Post: 01-12-2011, 08:49 AM
  4. Create new workbook based on Checkbox selections
    By Arun Sarathy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-24-2009, 09:39 AM
  5. Replies: 1
    Last Post: 04-11-2006, 12:30 PM

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