Matching Multiple Columns & Highlight Matches

Closed
Renae - May 4, 2010 at 11:04 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 5, 2010 at 12:18 AM
Hello,
I need to match related columns A and B to comparison columns D and E. A and D are assigned codes and will be compiled of random letter, numbers, and or symbols. Column D will sometimes contain multiple codes from column A with a space seperating the codes. Columns B is the amount connected to column A, and column E is connected to column D, as shown in the first line on my example D1 is a combination of A1 and A3 and E1 is the sum of B1 and B3. I would like to be able to identify all matches and highlight them. I currently work about 400 lines a day and would greatly appreciate some help in creating a macro to assist me.


A....................B....................C..........D..................E
a,1............$35,000.00....................a,1 t(0......$35,500.00
b2h...........$1,090.00......................5?/............$10.00
t(0............$500.00..........................b2h MR1...$1,160.00
f@2...........$903.65.........................4T<...........$87.50
JI5............$87.50............................?[..............$70.00
MR1..........$70.00............................G89...........$556.00
G89..........$556.00..........................f@2...........$903.65
.?{............$23,987,678.00.............JI5.............$87.50
t(0............$35.00...........................MR1...........$70.00
IO0...........$2.00.............................IO0............$3.00

Sincerely,
Renae
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 5, 2010 at 12:18 AM
what is the logic of connecting a1 and a3 similarly a2 and a6
0