Replace a row number with a dynamic cell value

  • In C1 I have VBA populate active row number upon each selection change.
    In G2 I have formula below, while trying to have the row number in column H replaced with value of C1 (the H&C1 bit).
    H5 = Sum for column H (I have totals on top). H6 where data $$ starts.
    This is to have G2 show remaining sum from total based on active row number in H.


    How ludicrous is that.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!