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

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT185-202.xls Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT218-220.xls Full Page With All File Links: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT218-220Finished.xls 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.