• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Searching Multiple Keywords in Excel 2010

Hi Experts,

Need your help with one thing

I have list of some values like;

Zengezur      13470      9498171      8      DH            RUSSIANS

SO, In total 8 columns of data

the macro i need is ;

+ i will put all the keywords on Sheet2
+ macro will check Column A for match (without case sensitive )
+ if of any matched values - excel to color the whole ROW in Yellow

VEry much appreciate to have your assitance

thx beforehand
1 Solution
Why not just do this manually?
It would help if you posted an example workbook.
Martin LissOlder than dirtCommented:
I'll be happy to help, but first can you tell me approximately how many rows of data we're dealing with? Also would it be possible for you to either attach the workbook or but together a sample workbook with a few lines of data?
SirjasonnAuthor Commented:
Have attached the file i will be dealing for your easy reference
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Martin LissOlder than dirtCommented:
You don't have a Sheet2 in the attached workbook. Is it Sheet3?
SirjasonnAuthor Commented:
i will add later on as Sheet2
Martin LissOlder than dirtCommented:
In order for me to provide you with a solution I need to know what sheet2 will look like. In other words where will the keywords be? In a particular column? If so will the be one or more heading rows?
Excel 2010, Tables
Advanced Filter
With macro
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now