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.

Maybe DataFilterAutofilter will work for you?


Gord Dibben MS Excel MVP

On Mon, 24 Sep 2007 13:30:01 -0700, 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.

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.

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.