Hi romperstomper,

This works almost perfectly. How can i make the pivot table start in A1 of the new sheet? It is spread across C:G.

Regards

Tim