D
Dave Potter
Just a note: The hardest thing about posting a message is choosing a
good subject!
Well here's what I have and what i want to do.
Have: XL2002 (Office XP Professional)
I am using drop down lists with data validation.
When I change the names in the list, how can get excel to
automatically update the drop down lists.
for example:
list 1
Harold
Gina
David
If I select Harold from the drop down list and then go back and change
the name Harold to Jimmy, the drop down list still says Harold.
I would like it to automatically change to Jimmy.
Since I am not well versed in VBA, a simple to understand explanation
would be great.
TIA
good subject!
Well here's what I have and what i want to do.
Have: XL2002 (Office XP Professional)
I am using drop down lists with data validation.
When I change the names in the list, how can get excel to
automatically update the drop down lists.
for example:
list 1
Harold
Gina
David
If I select Harold from the drop down list and then go back and change
the name Harold to Jimmy, the drop down list still says Harold.
I would like it to automatically change to Jimmy.
Since I am not well versed in VBA, a simple to understand explanation
would be great.
TIA