Datavalidation help: change value based on another datavalidation

[Dinesh121]

Hi All,

I have a named range as datavalidation in one cell and in another range I have the same named range. I would like to change the second data validation based on first one.

Eg:

In Cell A1 I have first data validation and in B2 i have second data validation. Both of them have same named range as input. If the user changes in A1 the same should reflect in B2. Also I would like to have the second datavalidation active. I don't want it to replace with a formula.

Thanks in advance for helping.

-Dinesh

 

[himanshu sharma]

share your file

 

[Dinesh121]

Attaching the file for reference.