Hi Guys,
This is my first post in Forum. Thanks for your help in advance.
I need help on this one. This is how it goes:
- I have approx 20 .xlsx files in a folder.
- I need to go through each file and look for a keyword in column H (Remark).
- Once the keyword is found, I need to highlight the same cell of that keyword in column I (Full Name), J (Mobile Number), O (License Plate), .
The keyword I’m looking for in column H (Remark) are: {number; name; registration}
Once the keyword is found then highlight the same cell of the keyword in it’s specific column.
Example (as per the attached file 11300 Wrong Number):
- In Column H > Row 1 > Keyword: ‘number’, ‘name’ > Keyword ‘number’ highlight cell J1 > Keyword ‘name’ highlight cell I1
- In Column H > Row 2 > Keyword: ‘number’, ‘name’ > Keyword ‘number’ highlight cell J1 > Keyword ‘name’ highlight cell I1
- In Column H > Row 3 > Keyword: ‘number’ > Keyword ‘number’ highlight cell J1
and so on…
Unfortunately, I cant’ upload the .xaml file that I have been doing and a .xlsx file…
If you need the file. Please provide me your email address and I will send them to you.
Please help. Thanks again.