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

excel+training - macros and pivot tables

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

excel+training - Macros and Pivot Tables

ResolvedVersion 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.

Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.