Possibly you can use VLOOKUP for the first question, hard to
tell from the information supplied see
http://www.mvps.org/dmcritchie/excel/vlookup.htm

The second question can be answered okay.
You might use an Event macro in the ThisWorkbook

Right click on the logo to the left of the menus in Excel
That should put you into ThisWorkBook of the current project (workbook)
Place the following code therein.

Sub WorkBook_Open()
WorkSheets("Sheet1").Activate
End Sub


References, the first is Gord Dibben
http://www.google.com/groups?threadm...0q% 404ax.com

http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Obi-Wan Kenobi" wrote in message
...

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