+ Reply to Thread
Results 1 to 3 of 3

Clearing data when i change selection on drop down lists

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    15

    Clearing data when i change selection on drop down lists

    Hi, I currently have a file where there are 4 data validation lists. The first one splits the world into 2 regions, the next 3 are all indirect lists which separates them by region and countries. I have information for each list which I would like to be cleared when I change the selection in the previous drop down list. How could I do this? Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: Clearing data when i change selection on drop down lists

    Hi and welcome to the forum

    To the best of my knowledge, this cannot be done with a regular formula.

    A few options come to mind though...
    Use Conditional formatting to test if the 2nd/3rd etc value is still valid, based on the value "before" it, and then either change its color if it doesnt match, of in a cell next to it, have text that says something like "needs to change" (or whatever you want), and have that text formatted (regular formatting) to white on white, then CF to change color for "no match" so it "appears"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Clearing data when i change selection on drop down lists

    Ah ok I see, and yes that would still be a helpful solution I will give that a try now, thanks very much!

+ 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. Data Query - How to Change Drop down Selection from Website
    By mattjac1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2013, 04:41 PM
  2. [SOLVED] Looking for an easy way to change data on a sheet based on drop-down selection
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 09:39 AM
  3. [SOLVED] How do you change source data for charts using drop down lists?
    By Dude to Excel Dude in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-16-2013, 02:16 PM
  4. Clearing out data validation lists when another changes?
    By Moody5782 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2012, 04:54 AM
  5. Drop Down Lists - assign a value based on selection
    By Neil M in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2005, 11:30 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