Creating a Search

's Computer Specifications

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.

's Computer Specifications

Maybe Data>Filter>Autofilter will work for you?

Gord Dibben MS Excel MVP

On Mon, 24 Sep 2007 13:30:01 -0700, Confused at Work
<(E-Mail Removed)> 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.

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating user input Search with 3rd party search engines	phl	Microsoft ASP .NET	0	19th Feb 2008 05:11 PM
Creating a Search Box	=?Utf-8?B?QVRvb2xDaGVzdC5Db20=?=	Microsoft Frontpage	1	12th Dec 2004 09:10 PM
Creating a search	=?Utf-8?B?TWFyY3k=?=	Microsoft Access Form Coding	1	30th Sep 2004 12:13 PM
Help creating a search	=?Utf-8?B?UGF1bCBCLg==?=	Microsoft Access Form Coding	0	20th Sep 2004 09:59 PM
creating a search	=?Utf-8?B?bWU=?=	Microsoft Access	1	14th Jan 2004 12:41 PM