Forum Discussion

Shawn French's avatar
Shawn French
Copper Contributor
Jan 30, 2019

Need Cell Contents to Disappear on Condition

Hello Forum!

 

Cell K11 is a data validation list with the following reference:

=INDIRECT(SUBSTITUTE($I$11," ","_"))

 

Cells L10, L11, and L12 are also conditional data validation lists of K11 with the following reference:

=OFFSET(INDIRECT(SUBSTITUTE($K$11," ","_")),1,0)

 

 

When the cell in K11 is edited, I want the contents of L10, L11, and L12 to disappear, as some of the exercises in K11 do not require any information from the following cells.

 

Here is an example of the list both of the cells are drawing information from:

 

 

Cell K11 is drawing from column B, and the lists in L10, L11, and L12 are drawing from the contents of D1 to G3.

 

Thank you all for your help, it is much appreciated.

 

Shawn

No RepliesBe the first to reply

Resources