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.

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.