Wednesday 21 January 2009

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

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


Video:


Description: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.

Published:
22/Jan/2009

No comments:

Post a Comment