From the course: Excel VBA: Managing Files and Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Advance one step forward in a PivotTable playlist - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
Advance one step forward in a PivotTable playlist
- [Instructor] When you create a pivot table playlist you record a series of macros and use VBA in combination with worksheet values to move through them. In this movie, I will show you how to create a macro that lets you move to the next position in your playlist. My sample file is 0703 advanced one. And that is a macro enabled workbook that you can find in the chapter seven folder of the exercise files collection. This workbook contains three worksheets and we're currently looking at the pivot worksheet which contains our pivot table. Sheet one contains the data in the form of an Excel table. And then there is the control worksheet. The control worksheet contains an Excel table which has a list of positions and descriptions. And then also in cell D2 which has selected the number of the current position. The positions table on the left is simply a guide for you. It doesn't figure into the VBA code at all. The idea…
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.