There's a sample file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Update Validation Selections'

user77a wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html