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

How to Import Formatted text as new Slides in PowerPoint 0
Countif 3
Syncing between source worksheet and dependent worksheets 0
Finding the right style field in VBA 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Finding the proper style field and the numbered paragraph value within the style 0
producing a report via a keyword - filtering and macros not suitab 2
Searching for keyword in sheet 1 and returning the whole row intosheet 2 4

Top