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?
Bookmarks