| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
building a search tool
Is there any way of building a search table on excel, so I can search large spreadsheet e.g. the search table is in sheet1 and the dat spreadsheet is in sheet2. Both sheets are linked. With in the searc table on sheet1 I want to have several search fields (Filters) thes will consist of a dropdown lists or boxes were I can freely type i information i.e. a customer name in cells this is then linked to th data spreadsheet on sheet2 and filters sheet 2 to bring up the custome record. Please see attached +------------------------------------------------------------------- |Filename: Customer search tool.zip |Download: http://www.excelforum.com/attachment.php?postid=4474 +------------------------------------------------------------------- -- Obi-Wan Kenob ----------------------------------------------------------------------- Obi-Wan Kenobi's Profile: http://www.excelforum.com/member.php...fo&userid=3257 View this thread: http://www.excelforum.com/showthread.php?threadid=52386 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Tool | Excel Discussion (Misc queries) | |||
| build a search tool in excel | Excel Discussion (Misc queries) | |||
| Build a search tool in excel | Excel Worksheet Functions | |||
| Build a search tool in excel | Excel Discussion (Misc queries) | |||
| Excel newsgroup search tool | Excel Programming | |||
Linear Mode
