From the course: Excel: PivotTables in Depth
Join today to access over 24,600 courses taught by industry experts.
Record and review an Excel macro
From the course: Excel: PivotTables in Depth
Record and review an Excel macro
- [Instructor] When you work with pivot tables, you'll often find that you want to recreate a specific configuration. You could write down the fields and the order in which they appear, but it might be easier to record a macro that records the position for you. In this movie, I will show you how to do that. My sample file is 08_01_Record and you can find it in the chapter eight folder of the exercise files collection. In this workbook, I have a pivot table that has SalesReg in the rows area and then OrderType in the columns area. And then we're summarizing the Sum of Order Total here. If I want to record a macro that will create this position, I can go to the View tab of the ribbon, and then at the far right, I'll click the Macros button and then click Record Macro. In the Record Macro dialogue box, I will change the name to CreatePosition. I won't add a description in this case or a shortcut key, but I could do that if I wanted to. And then I will click OK. So now Excel is recording…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.