Extracting Values from colored cells

  • The file is attached. The revised code is triggered when you click the "Calculate" button. The variable "Total" is the sum for the first anchor.

    Files

    • Final2.xlsm

      (28.16 kB, downloaded 54 times, last: )

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Hey, it is possible that when clicking on ok button next to riser number it shows anchor point and by clicking calculate button it adds all the value?

  • The file is attached. The revised code is triggered when you click the "Calculate" button. The variable "Total" is the sum for the first anchor.

    Thankyou so much it worked

    it just dont work with the ones not having loop location

    like for second anchor point it does not have a loop still it calculates the floor height.

    any suggestions for this?


    I made the following changes

    Files

    • Final2.xlsm

      (29.88 kB, downloaded 44 times, last: )
  • I'm sorry but I don't think that I can take this any further. :(

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.