Announcement

Collapse
No announcement yet.

Replace a row number with a dynamic cell value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    Hello,

    You can test following :

    Code:
    =SUM($H$5-(SUM(Indirect("H6:H"&C1))))
    Hope this will help
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      I came across a video last night about the Indirect function, and thought that would be exactly the way to address this matter - and it is - Thank you!

      Comment


      • #4


        Glad to hear it is all sorted out ...

        Thanks for your thanks ..And for the Like ...
        If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

        Comment

        Working...
        X