Creating a Search
 

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.

Creating a Search
 

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.

Creating a Search
 

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.

Creating a Search
 

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.