Hello, this is my first post so go easy on me! I have very little VB experience, so a built-in Excel function would be ideal.


I have two cells on the same worksheet (A1 and A2) - both are using the same validation list for data entry ("First" and "Second").
I would like to make both cells change value (to equal the other) when only one is modified using the drop down validation list.

Example:
Action 1) Choose "First" in cell A1 via validation drop down list.
Result 1) A1 and A2 show "First".

Action 2) Choose "Second" in cell A2 via validation drop down list.
Result 2) A1 and A2 show "Second".

Thank you in advance for the help.