Most valuable professional
  • Hot Topics

Excel clearing a cell based on dropdown value

I have been trying to code a solution but can only get it to work on one row.. column A has identical cells which are a dropdown with value 1 and 2. column b1, c1 and d1 have text entry cells which a user can put values in if A1=1 column e1, d1 and e1 have text entry cells which a user can put values in if A1=2 However if a user choses A1=1 and puts values in b1, c1 and d1, if they then change the A1=2 the cells b1, c1 and d1 should clear their contents. this should happen identically for each row down the sheet. currently i have one row working but can't get DIM to treat each row individually against the unique A? value e.g A3 should change row 3, etc. Any help very gratefully received.

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of April 1, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel