ExcelBanter - Create a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Create a macro (https://www.excelbanter.com/excel-discussion-misc-queries/233179-create-macro.html)

massa

Create a macro

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?

John

Create a macro

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?

All times are GMT +1. The time now is 02:48 PM.