excel microsoft training - Macro Pivot Tables

Hi Gary,

Thanks for your question.

To build MACROS:

• Select TOOLS menu > Macro
  
• Select RECORD NEW MACRO
  
• Name macro (no spaces / no special characters)
  
• Assign shortcut key if necessary
  
• Press OK & start recording the procedures
  
• to finish, press STOP RECORDING
  (under TOOLS menu > MACRO again)

• Click anywhere within your data table
  
• Select DATA menu > PivotTable & PivotChart Report
  
• Press NEXT, Confirm Data region, Press NEXT again.
  
• Select the location of new Pivot Table
  
• Press FINISH