Hi all,

On Sheet 1, I have a drop down list at Cell D9. This is linked with a
list kept somewhere in the same sheet and has a range name (list)

Now, I want a similar drop down in Sheet 2 with the same list and I
also want that when I select any items from Sheet 2, Sheet 1 should
also get changed with that item and vice versa.

Is there a way I can do this?

If there is any parent child concept here, I want Sheet 1 as the
parent and Sheet 2 as child.

Thanks in advance,
Anshuman