excel+training - macros and pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Macros and Pivot Tables

excel+training - Macros and Pivot Tables

resolvedResolved · Low Priority · Version Standard

Macros and Pivot Tables

Can a macro be recorded which will construct and format a Pivot Table, if so how can this be accomplished?

RE: Macros and Pivot Tables

Answer to the Question:
A Macro is a recording of All Key strokes and Mouse clicks, as such it will faithfully record your actions, and on command play them back. Macros are used to complete mundane and repetitive tasks accurately and without fuss.
If you require to create a Pivot table to Analyse or Summarise your database on a regular basis, recording your actions will allow you to replay them whenever you require.
Open the workbook in which you will be working, ensure you are on the worksheet with your list or database, choose the menu command Tools, Macro, Record New Macro, this will open a dialog box where you can set up your Macro; ie Name, any Keyboard shortcut, and some explanatory text. Once you click OK you are recording, be aware of Absolute and Relative Settings. When you have completed your actions, click the Stop Recording button and you Macro is ready to run.
For more information on Macros and Pivot Tables, look through this forum or they are covered in detail on the Excel Advanced Course.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quick Zooming in Excel with rollerball mouses

To zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time.

View all Excel hints and tips


Server loaded in 0.09 secs.