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

    You can say "THANK YOU" for help received by clicking the "Like" 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

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

Participate now!

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