Create pivot table using macro

[Brontosaurus]

Hi,

Could anyone show me how to create a pivot table using a macro please

I've attached a file containing the data and what the pivot table should look like in a new worksheet

I appreciate your help

Thanks

Steve

[arthurbr]

Hi, is there a particular reason you need a macro?

[Brontosaurus]

The reason is to provide someone who's unfamiliar with pivot tables, the ability to generate a report using them

Thanks

Steve

[arthurbr]

Steve,
as Pivot Tables are a built-in function, maybe you could create the first Pivot Table, using a dynamic range for data, and add a button to refresh the PT after some data is added. ( this button already exists in XL)

The person would then only have to add data and click the button