1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Query: Populate Drop Down List based on another Drop Down List

Discussion in 'Business Applications' started by mihaufo, Sep 19, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. mihaufo

    mihaufo Thread Starter

    Joined:
    Mar 15, 2012
    Messages:
    41
    Hi,

    I have a worksheet with gets updated regularly. (Sheet 2 in the attached file)
    Now, In Sheet1 I have two Drop Down Lists, on Selecting from first drop down, the corresponding values should be populated in the other Drop Down list.

    Thanks.
     

    Attached Files:

  2. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Made possible with link cell in dropdown 1
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1069533