Excel Forum
Similar Content
Reuse Pivot Table Filters in Row, Column, & Value Fields
Tutorial: 2 ways to add Pivot Table Filter Fields (page fields) to row, column, and value fields wh...
Easy Pivot Table in Excel (Auto-Subtotals Feature)
Tutorial: How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly ...
Add Background Photos / Images to Comments in Excel
Macro: Add background images and photos to your comments in Excel with this macro. This macr...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2


See how to create a Dynamic Range with the OFFSET function so a Macro to Create a Pivot Table will work even when new records are added. This method works in all versions.
Dynamic Range with the OFFSET function formula.





Got a Question? Ask it Here in the Forum.