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.