Results 1 to 13 of 13

Auto-clear dependent dropdown when parent cell is changed

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    Auto-clear dependent dropdown when parent cell is changed

    Hello!

    I have created some dependent drop downs that only give certain options when an item from the first column is selected. I'm wondering if there is a way to auto-clear the subsequent columns if the first column is changed? I have looked around a bit and have seen some VBA code stuff, but I'm an inexperienced user so it is all greek to me. Is there a way to do this with a formula within a cell?

    I've attached a sample. Please don't laugh at my crude attempts!

    Thanks and I hope to hear from you soon!

    Kim
    Attached Files Attached Files
    Last edited by Ceekimmy; 08-13-2012 at 11:58 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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