Tools Macro Record New Macro. Create the Pivot table manually then <ALT F11
to have a look at the Macro in the Module. Thats a starter. I'm guessing
you will need to modify the macro somewhere.

Regards,
John

"massa" wrote:

I need advice on how to create a macro in excel.
I have a spreadsheet that contains all the data. I want to create a macro
that will run a pivot table off of the data in the sheet when selected. Can
anyone help?