+ Reply to Thread
Results 1 to 3 of 3

Change cell from dropdown list and clear other cells in row

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Virginia Beach, VA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Change cell from dropdown list and clear other cells in row

    Thanks in advance for your help.

    I have dependent drop down lists in columns D,E and F. If someone changes any cell in these columns (D,E, or F) then I would like the other two cells to clear their contents so they then have to repick from the dependent list that matches that data chosen.

    Example - if they change E4, then D4 and F4 go blank. Or, if they change F4, then D4 and E4 go blank. And the same thing if D4 is changed, E4 and F4 go blank.

    The data for this worksheet begins at row 4 and at present time ends at row 6004.

    Thanks,
    Dale
    Last edited by Dale Schultz; 04-25-2012 at 03:12 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Change cell from dropdown list and clear other cells in row

    It would be easier to offer suggestions if you uploaded a sample file
    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
    03-21-2012
    Location
    Virginia Beach, VA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Change cell from dropdown list and clear other cells in row

    Thanks, I've attached a sample workbook as requested. I had to delete rows as it was too large to upload, but the worksheet goes to row 6004.
    Dale

    Sample Workbook.xlsx

+ Reply to Thread

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