Build a search tool in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Obi-Wan Kenobi - 17 Mar 2006 22:59 GMT

Is there any way I can build a search tool in excel so that I ca
retrieve data from another sheet. i.e. the search tool is built i
sheet1 and it can filter and retrieve data from sheet2.

Also is there a way of setting excel so that regardless of what sheet
may save the document it ALWAYS opens on sheet1.

Please advice.

:eek

--
Obi-Wan Kenob

Reply to this Message

David McRitchie - 18 Mar 2006 00:03 GMT

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=o57livg6oacpa458n5mk9nnqc4u9s2ce0q%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

> 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
[quoted text clipped - 5 lines]
> Please advice.
> :eek:

Reply to this Message