Create a macro

M

massa

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?
 
J

John

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
 
Top