MS Excel / VBA help thread

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

•

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 Sam_w @Sam_w started