Hello All members,

Iam using data validation list on a cell to create a dropdown in that cell. when i input some value in that cell it gives me an error because that value is not in the dropdown list.

Is there any way when i enter that value gets included in the dropdown list and cell dropdown gets updated?