+ Reply to Thread
Results 1 to 11 of 11

automated drop downlists the change upon selections

  1. #1
    Registered User
    Join Date
    04-10-2024
    Location
    Melbourne, Australia
    MS-Off Ver
    MS365 2403
    Posts
    17

    automated drop downlists the change upon selections

    hello.

    I am looking for some help please.

    I have data validated C3 and C4, however C5 is an option that changes based off C4 and C5. You can see the formula I have used for C5 located in F30.

    I need help creating a formula where when cell I20 (floorplan) is selected - cell specific, the only dropdown options to come up are G6-G20, whereas with all the other floorplan options, they will have all of the options in E6-G20 based off their model.

    Is this doable?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    640

    Re: automated drop downlists the change upon selections

    If you don't mind a helper column, put this somewhere:
    Please Login or Register  to view this content.
    Then in the data validation, select list and reference this cell, e.g. if you put this formula into cell K12, then this is:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-10-2024
    Location
    Melbourne, Australia
    MS-Off Ver
    MS365 2403
    Posts
    17

    Re: automated drop downlists the change upon selections

    hello, so it's not really what I need.

    When the option of "22' RD REAR CLUB LOUNGE" is to be selected as cell C4, i need the dropdown contents in C5 to reflect only the options of G6-G21. The rest was right in terms of models changing based off their floorplan, however I can't work out the 22' RD REAR CLUB LOUNGE issue

  4. #4
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    640

    Re: automated drop downlists the change upon selections

    I am not sure how this even makes sense.
    The header over G6 to G21 is 2020 Traction, which is a selection in C3.

    How is 22' RD REAR CLUB LOUNGE in C4 in any way related to this?

  5. #5
    Registered User
    Join Date
    04-10-2024
    Location
    Melbourne, Australia
    MS-Off Ver
    MS365 2403
    Posts
    17

    Re: automated drop downlists the change upon selections

    so there is 3 models which are are I4-I6 and the dropdown in C3.
    from there, there are 18 floorplans I9-I26, dropdown C4 which is used for each of the models.

    the issue that i'm having is 22' RD REAR CLUB LOUNGE is a completely different layout to the rest of the 17 and their option for C5 is G6-G21 regardless of the model. all the other floorplans just change with the model whereas 22' RD REAR CLUB LOUNGE
    is pretty much just the TRACTION inclusions

  6. #6
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    640

    Re: automated drop downlists the change upon selections

    Got it.
    See if the attached is too simplistic for your needs.
    I just put this into the data validation:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    04-10-2024
    Location
    Melbourne, Australia
    MS-Off Ver
    MS365 2403
    Posts
    17

    Re: automated drop downlists the change upon selections

    okay great that worked.
    but is there a way to incorporate a way so all the other floor plans have a drop down for the suspension?

  8. #8
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    640

    Re: automated drop downlists the change upon selections

    Is the attached what you're looking for?
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    04-10-2024
    Location
    Melbourne, Australia
    MS-Off Ver
    MS365 2403
    Posts
    17

    Re: automated drop downlists the change upon selections

    that was perfect, thank you so much. do you think you can help me with another issue?

    I need cell B7 (TV Points) dropdown list to change based off the selection in B5 and B6.

    The main concern I have is when cell H20 is selected in cell B6, I need the dropdown options in B7 to be the same as the red cells from D5 to F8 only. It's pretty much what we have worked on with the other document, except now I need the tv points to be based off model and floor plan rather than just floor plan with the other document
    Attached Files Attached Files

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: automated drop downlists the change upon selections

    This thread is solved. Please start a NEW thread with a suitable title for the new query. Thanks.

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

    Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: automated drop downlists the change upon selections

    Thanks for starting a new thread - you forgot to mark this one as SOLVED, though - please do so. 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. Replies: 4
    Last Post: 01-29-2023, 02:47 PM
  2. Replies: 5
    Last Post: 06-10-2020, 02:11 PM
  3. Replies: 2
    Last Post: 06-10-2020, 10:01 AM
  4. [SOLVED] Drop Down Selections
    By Delta729 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2018, 11:35 PM
  5. Replies: 1
    Last Post: 09-25-2013, 02:35 PM
  6. Combining selections from drop-down lists into a separate drop-down list
    By SCIFINUT in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-27-2012, 05:41 PM
  7. Multiple drop down selections
    By tortuga32 in forum Excel General
    Replies: 0
    Last Post: 02-04-2010, 08:28 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