• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Main table filling after scanning info in 2 supporting tables


New Member
While testing my response to your last question I noticed that once a colour has been changed it is difficult to get the sheet to re-calculate, so I've made a very small tweak to the user-defined function. Now, once you've changed a colour it should update automatically, but if it doesn't you can make it recalculate by pressing F9 on the key board.
Alteration in attached.
I tried changing the colours and updates were automatic. Wonderful!

Thank you very much :)