I have two cells I fill out 20-40 times a day, NAME and TITLE, and I
have a drop down box in which I have the titles. Is there a way I can
make it so that my sheet "remembers" a NAME and auto fills the title,
and, updates itself both name and title if it doesn't recognize the
name?
So next time I happen to type that name the title fills. I am sort of
proficient with excel, so fire away.

Thanx for any input....

Ryk