Results 1 to 3 of 3

Data Validation, clear data if parent dropdown is changed

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    85

    Data Validation, clear data if parent dropdown is changed

    Hi

    My spreadsheet consists of drop down menu's that are reliant on the previous drop down.

    Let's say
    A1 - Sales/Variance
    A2 - Type of sale or type or variance
    A3 - Reason

    However, I have noticed that if all three have been selected and then A1 was changed from Sales to Variance, the drop down for A2 and 3 would now not be applicable as the options are different. How would I clear this?

    So far I am using Data Validation only.

    Thanks
    Last edited by MushroomFace; 05-20-2015 at 10:56 AM. Reason: Moved from Excel General to VBA

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-clear dependent dropdown when parent cell is changed
    By Ceekimmy in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 10-03-2023, 02:01 AM
  2. [SOLVED] Clear multiple cells when a dropdown is changed and reset to today's date
    By GregHorn27 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2015, 10:37 AM
  3. [SOLVED] Auto-clear entire row with dependent dropdown lists when parent cell is changed
    By betheeem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2015, 09:56 AM
  4. Replies: 2
    Last Post: 06-10-2013, 09:41 AM
  5. Clear cell contents when validation box is changed.
    By bujaman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2010, 10:11 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