Hello,
I need help with excel dropdown list. I'm using office 2007. What I'm tring to accopmplist is when I click on a name in dropdown A1 is changes to the correct name in dropdown H1

So it will be:

Bill Smith
Ted Williams
Bobby Knight
Jim Jones
John Smith

I have created the following dropdown list:

A1

Bill
Ted
Bobby
Jim
John

H1
Smith
Williams
Knight
Jones
Smith