The best way to create a Keyword Seach field in excel

  • Thread starter Thread starter thallingdvss
  • Start date Start date
T

thallingdvss

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.
 
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
 
Back
Top