+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    10

    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?
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

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

    Try this

    Please Login or Register  to view this content.
    In your example,rows 14 onwards need to be blank.
    Martin

  3. #3
    Registered User
    Join Date
    08-27-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    10

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

    Thank you so much!
    It really worked!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1