Recording and reviewing a macro


show more Recording and reviewing a macro provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Recording and reviewing a macro

When you work with PivotTables you will often find that you want to recreate a particular configuration. You could write down the fields in the order in which they appear, but it's far easier to record a macro that configures a PivotTable for you. So I have a PivotTable that contains sales data for FirmA and FirmB and it's monthly for the years 2009 and 2010 and I also have the Quarter field up here in the Report Filters area and my goal is to recreate this configuration by using a macro. So the first thing we need to do is start recording the macro.

To do that we click the View tab on the Ribbon, click the Macros button's down arrow, and then click Record Macro and I will type in a macro name and I will just call it FirstPosition and now I will click OK and Excel will start recording my actions. The first step to recording a PivotTable macro in Excel is to clear the entire PivotTable and to recreate it from scratch. So in this case, with a cell in the PivotTable selected, I ...

Recording and reviewing a macro
Video duration: 4m 10s 3h 43m Intermediate

Viewers:

Recording and reviewing a macro provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...