I've got a large statistical return that I need to build about half a dozen quite complex pivot tables from. Good news - I have last year's version that I can clone these pivot tables from. Bad news - there are a handful of extra columns in this year's source data so I can't just do a straight copy & paste/clone.
Pivot table help needed please!
I've got a large statistical return that I need to build about half a dozen quite complex pivot tables from. Good news - I have last year's version that I can clone these pivot tables from. Bad news - there are a handful of extra columns in this year's source data so I can't just do a straight copy & paste/clone.
Is there a straightforward solution to this?