Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Obi-Wan Kenobi
 
Posts: n/a
Default Build a search tool in excel


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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default Build a search tool in excel

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Binocular search tool, Excel, loses column designation at "Find" Little Rock Ette Excel Discussion (Misc queries) 1 November 16th 05 04:54 PM
dump file search results into excel Nadia Excel Discussion (Misc queries) 2 July 29th 05 02:43 AM
Excel 2003 SP 1 does not search for files on a removable HDD Dmitry Kopnichev Excel Discussion (Misc queries) 4 July 25th 05 08:04 AM
Excel Search Utility ckjaime Excel Discussion (Misc queries) 2 July 15th 05 04:54 AM
how to search in excel with condition David Excel Discussion (Misc queries) 1 February 8th 05 09:23 PM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"