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.