MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

Sam_w in reply to @Chalfie

Could certainly be done with a pivot, but then you have to remember to refresh the pivot each time, or code something to do it for you...

•

Chalfie in reply to @Sam_w

Even if you put the data in a table?

I'm a fan of writing stuff as then you know what you're counting and why.
Again, tables make this easier.

•

Sam_w in reply to @Chalfie

Good question, potentially, I tend to avoid pivot tables as I like to be able to trace formulas, but I am weird.

Could also set pivot table to autorefresh on opening which would probably help a lot too.

About

Avatar for Chalfie @Chalfie started