Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Dynamically Filled Validation Lists

  1. #1
    Join Date
    16th April 2005
    Registered Users

    Dynamically Filled Validation Lists

    I’m trying to come up with a piece of VBA that will allow me to create a dropdown list that can change based on the value of another dropdown list, which in turn is based on the values in a column.

    In the attached file you will see I have a table E3:F9. The ‘Get Names’ button contains a very simple macro which does an advanced filter of the names and copies them to N1, this means that filter on I3 now contains the two name ‘Fred’ and ‘Jess’.

    What I would like to happen is when a user selects Fred from the dropdown (I3) then in the second dropdown (J3) will appear a unique list of Fred’s processes (namely: P57, P89,P90) and of course in turn if the user selects Jess from the ‘I3’ dropdown, then Jess’ processes will appear in the ‘J3’ dropdown, (namely: P890, P789, P677).

    As you can tell the ‘J3’ dropdown is run from the values in Column ‘O’. Therefore what I’m really after is a way I can dump the unique list of a user’s processes into Column ‘O’ after a name has been selected using the ‘I3’ dropdown.

    Any clues??????????

    Thanks in advance

    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003

    Re: Dynamically Filled Validation Lists

    Hover over Validation and read Dependent Validation Lists

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: February 18th, 2008, 10:37
  2. Conditional Validation Lists
    By Mezari in forum Excel General
    Replies: 4
    Last Post: November 23rd, 2005, 09:39
  3. HELP with Validation Lists
    By jeffkahn in forum Excel General
    Replies: 1
    Last Post: December 15th, 2004, 04:20
  4. Replies: 2
    Last Post: February 9th, 2004, 01:35
  5. Data Validation: Corresponding Validation Lists
    By torpedo13 in forum Excel General
    Replies: 1
    Last Post: August 9th, 2003, 11:44


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts