excel 2003
1. user selects value (cell) from a drop down list
2. the selected drop down list cell value changes
I want the value selected in (1) to reflect the change in value in (2)
I understand I must us a macro "change event"
Can someone please help