+ Reply to Thread
Results 1 to 4 of 4

Dependent Drop Down Lists

  1. #1
    Registered User
    Join Date
    01-10-2020
    Location
    Peterborough, England
    MS-Off Ver
    Office 2016
    Posts
    25

    Dependent Drop Down Lists

    Hi all,

    I'm trying to set up some dependent drop down lists. I have attached a sample for editing and reviewing

    On sheet 2 there is the raw data and i have placed an example of what i need to happen on sheet 1.

    I need it to populate the right AMOUNT and VAT BREAKDOWN when the council and search type are selected from the dropdown.

    Can anyone help?

    Thank you
    Attached Files Attached Files
    Last edited by danmolesworth; 01-27-2020 at 12:33 PM.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Dependent Drop Down Lists

    Insert a helper column (blank column) on sheet 2 between col. B and C. Fill down the blanks in sheet 2 col. A.
    In your helper column, enter =A1&B1. Copy down.

    On sheet 1 enter this into F2:
    Please Login or Register  to view this content.
    copy down

    On sheet 1 enter this into G2:
    Please Login or Register  to view this content.
    copy down

    Please remove any trailing spaces in your looked up data.

    Pete
    Last edited by PeteABC123; 01-27-2020 at 11:57 AM.

  3. #3
    Registered User
    Join Date
    01-10-2020
    Location
    Peterborough, England
    MS-Off Ver
    Office 2016
    Posts
    25

    Re: Dependent Drop Down Lists

    Thanks Pete!

    This worked perfectly!

  4. #4
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Dependent Drop Down Lists

    Great!

    If this did the trick, please mark this issue as SOLVED. . .(in thread tools at the top.)

    Cheerio Pip Pip

+ 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: 11
    Last Post: 10-08-2021, 04:55 AM
  2. Replies: 4
    Last Post: 01-27-2020, 09:32 AM
  3. Dependent drop down lists
    By tamaramb in forum Excel General
    Replies: 2
    Last Post: 10-06-2016, 06:19 AM
  4. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  5. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  6. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  7. Dependent Drop Down lists (multiple drop down)
    By jijy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 09:56 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