| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
build a search tool in excel
Is there any way of building a search table on excel, so I can search a large spreadsheet e.g. the search table is in sheet1 and the data spreadsheet is in sheet2. Both sheets are linked. With in the search table on sheet1 I want to have several search fields (Filters) these will consist of a dropdown lists or boxes were I can freely type in information i.e. a customer name in cells this is then linked to the data spreadsheet on sheet2 and filters sheet 2 to bring up the customer record. Please see attached zip file. +-------------------------------------------------------------------+ |Filename: Customer search tool.zip | |Download: http://www.excelforum.com/attachment.php?postid=4472 | +-------------------------------------------------------------------+ -- 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=523867 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Binocular search tool, Excel, loses column designation at "Find" | Excel Discussion (Misc queries) | |||
| dump file search results into excel | Excel Discussion (Misc queries) | |||
| Excel 2003 SP 1 does not search for files on a removable HDD | Excel Discussion (Misc queries) | |||
| Excel Search Utility | Excel Discussion (Misc queries) | |||
| how to search in excel with condition | Excel Discussion (Misc queries) | |||
Linear Mode
