Creating a pivot table using Macro

[McQLon]

Hi,

I have a table of raw data that changes on a weekly basis and I want to be able to put this raw data into a pivot table as and when needed using a macro in order to speed things up. The number of columns remains the same but the number of rows changes continuously. (example attached).

Each time I record a macro and go through the steps one by one the macro stops and needs debugging at the stage of creating the pivot.

Can anyone help?


Thanks

[Cheeky Charlie]

Use a dynamic named range for your pivot table - then you don't need to recreate every time, you can just append new data.

No coding necessary.

http://www.ozgrid.com/Excel/DynamicRanges.htm


HTH