+ Reply to Thread
Results 1 to 2 of 2

Populating dropdown list

  1. #1
    Registered User
    Join Date
    09-23-2024
    Location
    United States
    MS-Off Ver
    365
    Posts
    2

    Populating dropdown list

    This is a simplified version of my table:

    Screenshot from 2024-09-23 17-42-25.png

    I know how to create a dropdown with ALL the employees, but I need to create a dropdown with ONLY those employees who happen to be drivers. Any help would be greatly appreciated.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,934

    Re: Populating dropdown list

    Welcome to the Forum gigowski !

    It is much better to attach an Excel file to your post than a screen shot. Then we don't have to type in your data, and we can return a file that has a solution implemented.

    Let's say your table name is Table3.

    Pick an out-of-the-way cell to put this formula. Let's say G1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Now use this as a data validation rule with a list:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Replies: 6
    Last Post: 01-20-2024, 08:32 PM
  2. [SOLVED] Populating information based on selection from dropdown list
    By kearbear in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2013, 11:16 PM
  3. Populating worksheets info from Dropdown list
    By bgreen66 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-11-2013, 04:27 AM
  4. Replies: 1
    Last Post: 05-02-2011, 10:09 PM
  5. Populating numerical values in adjacent cell from using a dropdown list
    By up_and_under in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-30-2010, 10:30 AM
  6. Dropdown list for populating data from other sheet
    By raghavfastest in forum Excel General
    Replies: 2
    Last Post: 01-12-2009, 08:05 AM
  7. populating a dropdown based on choice from a previous dropdown
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2006, 03:20 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