Matching Multiple Columns & Highlight Matches [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
796
what is the logic of connecting a1 and a3 similarly a2 and a6

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!