building a search tool

Is there any way of building a search table on excel, so I can search a large spreadsheet e.g. the search table is in sheet1 and the data spreadsheet is in sheet2. Both sheets are linked. With in the search table on sheet1 I want to have several search fields (Filters) these will consist of a dropdown lists or boxes were I can freely type in information i.e. a customer name in cells this is then linked to the data spreadsheet on sheet2 and filters sheet 2 to bring up the customer record.

Please see attached.

multi posted

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Obi-Wan Kenobi"
<Obi-Wan.Kenobi.24v7jn_1142684701.5804@excelforum-nospam.com> wrote in
message news:Obi-Wan.Kenobi.24v7jn_1142684701.5804@excelforum-nospam.com...
>
> Is there any way of building a search table on excel, so I can search a
> large spreadsheet e.g. the search table is in sheet1 and the data
> spreadsheet is in sheet2. Both sheets are linked. With in the search
> table on sheet1 I want to have several search fields (Filters) these
> will consist of a dropdown lists or boxes were I can freely type in
> information i.e. a customer name in cells this is then linked to the
> data spreadsheet on sheet2 and filters sheet 2 to bring up the customer
> record.
>
> Please see attached.
>
>
> +-------------------------------------------------------------------+
> |Filename: Customer search tool.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4474 |
> +-------------------------------------------------------------------+
>
> --
> Obi-Wan Kenobi
> ------------------------------------------------------------------------
> Obi-Wan Kenobi's Profile:
> http://www.excelforum.com/member.php...o&userid=32578
> View this thread: http://www.excelforum.com/showthread...hreadid=523869
>