What about using control-f to find them. I know it isn't very exciting but it
works.

"Confused at Work" wrote:

Just wondering I have a list of Customers from A1 to A500 Column 1 with all
addresses and information hyperlinked to a seperate worksheet. Instead of
going through each one and scrolling down in alphabetical order is there a
way at the top of the page to have a search cell, where I just type in the
first 5 to six letters and the information comes up and I click on it and it
then takes me to their customer information?

Thanks for your help.