How Do You Select Pivot Table Functions In An Excel Macro?
MS Excel is Microsoft’s most popular spreadsheet application. The program allows users to organize and process large amounts of data with just a few keystrokes. One of the most popular reporting formats created by Excel is the PivotTable. This is an interactive table with user defined fields. Another popular tool is the Macro, which is a customized program created by the user. Put together, the PivotTable and the Macro allow for a very powerful tool-set. Go to the Tools menu and click “Macro.” Click “Record New Macro.” Name the macro or give it a keyboard shortcut. You can also skip this step by clicking “OK” to begin recording the macro. Open the workbook where you want to make the PivotTable. Click “PivotTable and PivotChart Report” on the Data menu. Select the type of data you will use and then follow the instructions for locating your data file. Click “Finish” to close the PivotTable wizard. Click “Stop Recording Macro.” This will end the PivotTable macro you just created.
