Macro to calc. #'s btwn variable rows/columns corresponding to an adjacent populated cell

Good Morning all,

I am really trying to create a macro that would would calculate the difference between "ACWP" and "EAC".

However, the attributes ["ACWP" & "EAC"] vary each time I run my report.

I've attached an Excel spreadsheet to show you an example of what the original data looks like and what I'm wanting my end result to be.

I would like, for my end result, EAC lines that shows the difference between "ACWP" and "EAC".

Keeping in mind that:

If I only have "ACWP", my result will only equal that populated cell for "ACWP"

If I only have "EAC", my result will only equal that populated cell for "EAC"

If my Budget Element XX has both an "ACWP" line and an "EAC" attribute, I would like "ACWP" - "EAC" to be the value in my end result.

Is a macro for this possible?

Thank you so much!
It really worked!