gtc001
01-13-2017, 03:25 PM
Need help with a macro that will per the [Operation] will or if the operation is the same
1. Match amounts when added together = 0 (86, -86) and label them "1"In column AB
2 Then If operation is the same and if there is not a "1" in Column AB sum all the other Amounts that may equal one to many For Example ( 1,078.55+ 9,670.00 = 10,748.55) and label "2 "in Column AB
3. Highlight the Amount Cells Green if there is a 1 or 2 in Column AB
Attach is example of data. I highlight 2 groups that add to zero and sum to zero once a test is run. There may be more that net to zero
1. Match amounts when added together = 0 (86, -86) and label them "1"In column AB
2 Then If operation is the same and if there is not a "1" in Column AB sum all the other Amounts that may equal one to many For Example ( 1,078.55+ 9,670.00 = 10,748.55) and label "2 "in Column AB
3. Highlight the Amount Cells Green if there is a 1 or 2 in Column AB
Attach is example of data. I highlight 2 groups that add to zero and sum to zero once a test is run. There may be more that net to zero