You can record a macro as you create the pivot table and then assign the
macro to a button for future use.

"anu" wrote:

Hi,

I want a macro for creating a pivot table.
Pivot table has one row field, one column field and one data field (where I
want a count of data). After this I want to rename the pivot table new sheet.
However it give me an error called "subscript out of range" & "Run time
error 9".
Can any one please help me with this?

Many Thanks