+ Reply to Thread
Results 1 to 3 of 3

Dropdown list to show relevant options

  1. #1
    Registered User
    Join Date
    06-23-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Dropdown list to show relevant options

    Hi

    I currently have a spreadsheet that shows transactions from different companies. I would like to adjust the dropdown list to only show the relevant transaction types.

    EXCEL.png

    Currently there is a named range setup (I9:I20) which is where the dropdown gets its list from.

    I added a column to the left with the different companies and wondered if the dropdown for 'Transaction Type' can only show the necessary dropdowns.

    So for example if I select the 'Transaction Type' dropdown under Square Company, it should only show 'Lease', 'Surrender of Lease' and 'Abortive Sale'.

    The Spreadsheet is just a replica of another to try and simplify it hopefully.

    thanks
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    Microsoft Office 365
    Posts
    1,163

    Re: Dropdown list to show relevant options

    See My attached workbook.

    Pretty much you need to rearrange your table so companies are on the top and transactions for each are below them. Then you need to name your individual tables based on the Developer name. Just remember you can't use "SPACE" when naming a table.
    Once all tables are named you then have to make a data validation list based on the company name so you will utilize this formula in the data validation list:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Above formula references the company name in column C and removes spaces so that it will match the name of your tables hence giving you the correct drop down lists.
    Attached Files Attached Files
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Registered User
    Join Date
    06-23-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Re: Dropdown list to show relevant options

    Many Thanks,

    I originally did that first part by splitting the developers into columns but was using named ranges for the list validation.

    This formula works better though as it auto fills the next rows automatically and works providing you add the new column for the developer.

    Thanks

+ 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. VBA Formula to show task list relevant to event dates across worksheets
    By Sawfish in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-21-2016, 02:07 AM
  2. Print all options from dropdown list to PDF and name the files the exact names in the list
    By johnwilliamboyle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2014, 11:49 AM
  3. Replies: 8
    Last Post: 02-12-2014, 05:16 PM
  4. Replies: 2
    Last Post: 08-05-2013, 10:08 PM
  5. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  6. [SOLVED] Formula to check pre-defined list and show relevant info
    By galvinpaddy in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:43 AM
  7. Dropdown list options
    By Back2Basics in forum Excel General
    Replies: 4
    Last Post: 02-10-2009, 10:04 AM

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