Pivot table help
 

Using excel2002, can someone provide me the vba code to create a pivot
table by clicking a command button on sheet "DealerData." I would like
the code to automatically create a separate sheet. I have 6
columns(A:F) of data that runs between 3 to 100's of rows.

Pivot table help
 

The best way to get the code is to create it manually with the macro recorder
turned on. Then modify the code to include any special considerations such
as a dynamic range.

--
Regards,
Tom Ogilvy



"L Scholes" wrote:

Using excel2002, can someone provide me the vba code to create a pivot
table by clicking a command button on sheet "DealerData." I would like
the code to automatically create a separate sheet. I have 6
columns(A:F) of data that runs between 3 to 100's of rows.