Hi,
I receive an Excel workbook every month containing a large of amount of costing data formatted in the same way.
There is a good opportunity to interrogate this data using Pivot Tables.
However, I wish to have the same pivot table format effectively as a template and apply it to the workbook in the same way every month. This pivot table would be located in its own workbook.
Is this possible without having to build the Pivot Table each month using the wizard?