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?
Try this Please Login or Register to view this content. In your example,rows 14 onwards need to be blank.
Please Login or Register to view this content.
Martin
Thank you so much! It really worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks