+ Reply to Thread
Results 1 to 2 of 2

Dynamic Drop Down allows users to select invalid combinations

Hybrid View

keptbybees Dynamic Drop Down allows... 04-04-2024, 07:02 AM
AliGW Re: Dynamic Drop Down allows... 04-04-2024, 07:05 AM
  1. 04-04-2024, 07:02 AM #1
    keptbybees is offline
    Registered User
    Join Date
    03-28-2023
    Location
    Cardiff, UK
    MS-Off Ver
    MS365 Version 2403
    Posts
    8

    Dynamic Drop Down allows users to select invalid combinations

    Hello! I have a spreadsheet here which uses a dynamic drop down list. The user selects a customer in drop-down 1. Drop down 2 displays a list of products to choose from which are specific to the customer selected in the first. My issue is that if Customer 1 (for example) and one of their products is selected, the user is able to go back into the first dropdown and change it to Customer 2, and the value in the second drop down is still allowed to be a Customer 1 specific product. I think I could get around this with a macro, but I'm not amazing at them and I can't get it to work. Any ideas would be greatly appreciated Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-04-2024, 07:05 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: Dynamic Drop Down allows users to select invalid combinations

    Administrative Note:

    Is your forum profile showing the Excel PRODUCT that you need this to work for?

    Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

    The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

    Thanks.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamic excel dashboards with drop down select criteria menu
    By Lycias in forum Office 365
    Replies: 0
    Last Post: 07-25-2021, 04:53 AM
  2. [SOLVED] Using a Dynamic Drop down to select data to display.
    By PheoBlue in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2020, 11:20 AM
  3. Invalid or unqualified reference on range select
    By Poulan in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-12-2014, 01:22 PM
  4. Dynamic Chart - Invalid reference error message
    By Anthony2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-12-2014, 04:00 AM
  5. All possible combinations from dynamic list
    By SymphonyTomorrow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-01-2013, 01:03 AM
  6. [SOLVED] VBA to hinder users from entering invalid entries when using drop-down lists
    By alchavar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2013, 03:03 PM
  7. [SOLVED] Invalid Picture error for new users.
    By Jodi.Familo@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2006, 01:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1