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.


    =SUM($H$5-(SUM($H$6:H&C1)))


    How ludicrous is that.

Participate now!

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