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.