Macro to check sub totals

[bd528]

Hello,

Please see attached.

I'd like a macro to total up all the values in column E, and then add that to the corresponding value in column C. If that total does not match the value in column D, then the macro should highlight the relevant code, as in the "After" section.
So, for the first code "SPE997", 1&1&2&1 = 5, so SPE997 is not highlighted.
There can be any number of codes (I've just used 3 in the example), but the last row to check will always be the last row with an entry in column B.

I'd be glad of any help with this. Thanks in advance!