Speed up Macro

[p45cal]

I'm amazed that using a Dictionary is ~100x faster than using arrays and built-in functions (e.g. TEST)
I'd have thought that building the dictionary and looking up indexes would have added more overhead

See if I've done anything wrong in the attached.
Stuff gets put in the Immediate pane of the VBE which can be copy/pasted to a sheet and a pivot table created.

framcc06, I won't be able to do anything until tomorrow afternoon (UK time).