Sirjasonn
asked on
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
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
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?
ASKER
Have attached the file i will be dealing for your easy reference
1-20000-gemiler.xlsx
1-20000-gemiler.xlsx
You don't have a Sheet2 in the attached workbook. Is it Sheet3?
ASKER
i will add later on as Sheet2
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It would help if you posted an example workbook.