Forum Discussion
Shawn French
Jan 30, 2019Copper Contributor
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