The best way to create a Keyword Seach field in excel

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.
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif 2
producing a report via a keyword - filtering and macros not suitab 1
compare and return a value from another worksheet 3
Macro options in Excell 2003 1
Go to a chosen worksheet 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Searching for keyword in sheet 1 and returning the whole row intosheet 2 4
Vlookup 10

Top