how to auto update these values?

Col B shows the total count for each color category. It does this by referencing Col E (vba script). As you add colors to "status" (col e) it updates my totals. However, it does NOT auto update. I have manually change the value of Col A (for each color) for it to update Col B.

How do I make column B auto update? I am also fine with a refresh button that will do "something" with col A, but I need to keep those values as is in col A

Thank you



..

Attachment 790478


Attachment 790479

eeps24, it is very difficult to test code performance on images.
Try to assign a macro to the button:

Please Login or Register  to view this content.

Artik

Thanks Artik, I am not good with VBA (I found my code from someone else). I have updated a sample copy. Can you please take a look and see if it updates? I tried to use your code but it didnt work, perhaps I did something wrong.

Thank you!

There is no RefreshCounter macro in the workbook shown, so it's hard for anything to work.
Changing the fill color of a cell doesn't trigger typical Excel events, which would be useful for forcing a recalculation of formulas. Admittedly, there are methods that can replace Excel events, but each of them has some drawbacks.
If you accept manually forcing the recalculation of formulas, then one of the following three macros associated with the button should help.
The first two macros refer to the source ranges of the GetColorCount formulas. "Changing" the values (even if they are the same values) in the cells referenced by the function causes the function to recalculate.
The third macro forces recalculation of all formulas (not just GetColorCount) in the active sheet.

The choice of method is up to you.

Please Login or Register  to view this content.

Artik