From the course: Excel VBA: Managing Files and Data
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Move to any PivotTable playlist position - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
Move to any PivotTable playlist position
- [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 it. In this movie, I will show you how to create a set of macros that let you move forward and backward through your playlist or to any specific position. My sample file is O7O4, move to any and that is a macro enabled workbook that you can find in the chapter seven folder of your exercise files collection. This workbook and the code of contains is modeled very closely on the code from the previous movie. So if you haven't had a chance to watch that movie yet, please do because I'm going to be pointing out the differences between these two worksheets and not going through everything in detail. The pivot worksheet contains a pivot table and it is based on the Excel table and sheet one and then on the control worksheet, we have a list of positions and descriptions, and then…
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.