software

Is there any way I can build a search tool in excel so that I can
retrieve data from another sheet. i.e. the search tool is built in
sheet1 and it can filter and retrieve data from sheet2.Also is there a way of setting excel so that regardless of what sheet I
may save the document it ALWAYS opens on sheet1.

Please advice.--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile: www.excelforum.com/member.php...oamp;userid=32578
View this thread: www.excelforum.com/showthread...hreadid=523792You can do this with Advanced Filters and programming. There are some
sample workbooks he

www.contextures.com/excelfiles.html

Under Filters, look for 'Product List by Category' and 'Filter Rows for
Text String'

Obi-Wan Kenobi wrote:
gt; Is there any way I can build a search tool in excel so that I can
gt; retrieve data from another sheet. i.e. the search tool is built in
gt; sheet1 and it can filter and retrieve data from sheet2.
gt;
gt;
gt; Also is there a way of setting excel so that regardless of what sheet I
gt; may save the document it ALWAYS opens on sheet1.
gt;
gt; Please advice.
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html