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

Would a pivot have solved this?

•

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.

About

Avatar for Sam_w @Sam_w started