Excel Forum



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.