+ Reply to Thread
Results 1 to 5 of 5

auto refresh the data to blank if another cell data is changed

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    malaysia
    Posts
    89

    auto refresh the data to blank if another cell data is changed

    Dear all,

    i am facing a problem to verify the data accuracy if 1 data is been changed, another data must auto set to blank.


    i upload my excel file herewith.

    refer to my sheet 1.
    i have 2 columns, column 1 and column 2.
    column 1 is the category, and column 2 is the items of the category.

    for example, if column 1 is choose fruit in the drop down list, the item in drop down list in column 2 will auto display the different type of fruit.
    columns 2 data is depends on the category of column 1 select.


    my problem is when user select the column 1 and then go to select column 2.
    then user go to change the category in column 1 without change the data in column 2.
    then 2 column data is not matching.

    how to make the column 2 data auto refresh and set to blank when user edit the data in column 1?
    or prompt an error message if 2 column of data is not matching?

    looking forward from your all.
    Attached Files Attached Files
    Last edited by ccs1981; 06-10-2013 at 02:33 AM.

  2. #2
    Registered User
    Join Date
    09-16-2008
    Location
    malaysia
    Posts
    89

    Re: auto refresh the data to blank if another cell data is changed

    anyone can help me?

    help~~

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: auto refresh the data to blank if another cell data is changed

    Pl try this worksheet event.

    Right click on SHEET1 tab
    Viewcode
    Copy this code to VB sheet.
    Close the VB sheet.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-16-2008
    Location
    malaysia
    Posts
    89

    Re: auto refresh the data to blank if another cell data is changed

    thank you so much. you had solved my problem.
    really appreciated it.

  5. #5
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: auto refresh the data to blank if another cell data is changed

    A similar code below will look at any change in the entire first column then clear the contents in the cell to the right of the activecell:

    Please Login or Register  to view this content.

+ 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