| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The best way to create a Keyword Seach field in excel
I have a workbook that has two worksheets. Worksheet 1 is an items list and
Worksheet 2 is a Price Proposal. I need to create a cell on Worksheet 2 that says Keyword Search. The purpose is so a sales rep can type in a word or two, the macro would then copy that word from WOrksheet 2 go to Worksheet 1, filter on description, contains and then paste that word in and then you would be left with all of the items that contained that word. This only works for the first search. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The best way to create a Keyword Seach field in excel
Hi
Without seeing you macro, this can only be a guess. I think you need to show all data before you apply a new filter. Hopes this helps, otherwise post your macro. Regards, Per On 28 Sep., 21:25, thallingdvss wrote: I have a workbook that has two worksheets. *Worksheet 1 is an items list and Worksheet 2 is a Price Proposal. *I need to create a cell on Worksheet 2 that says Keyword Search. *The purpose is so a sales rep can type in a word or two, the macro would then copy that word from WOrksheet 2 go to Worksheet 1, filter on *description, contains and then paste that word in and then you would be left with all of the items that contained that word. *This only works for the first search. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel seach | Excel Worksheet Functions | |||
| How do I create a Title row or field in Excel 2003? | New Users to Excel | |||
| create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel | |||
| How do I create a query field in Excel | Excel Discussion (Misc queries) | |||
| Excel Forumla to seach and return all values | Excel Worksheet Functions | |||
Linear Mode
