CODEWITHSUNDEEP
excel
Klaas
Klaas

Reputation: 49

data validation list based on checkbox value

right now i have a table with information like company name and stuff.

after each line in the table there is a checkbox.

i also have data validation list that references to that table.

is there any way that only the lines in the data validation show if in the table the checkbox behind a line is ticked?

so for example i have this

**name checkbox**
test checked
klas unchecked
klek checked

and then in the list in only shows test and klek and not the klas option since that is unchecked.

Upvotes: 0

Views: 224

Answers (1)

Harun24hr
Harun24hr

Reputation: 36945

Download the file and check it.

Sample File Download Link

I thought it would be easier but not. I am sure it will take hours to understand what is happening with formulas.

Upvotes: 1

Related Questions