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: http://www.excelforum.com/member.php...o&userid=32578
View this thread: http://www.excelforum.com/showthread...hreadid=523781