Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
12,553
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 21, 2009

See how to use an Excel 2007 Table to create a Dynamic Range so a Macro to Create a Pivot Table will work even when new records are added.

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (4)

Sign In or Sign Up now to post a comment!
  • Awesome stuff man! This will save me countless hours of manual updates.

  • all your videos are very informative. Thanks so much for posting these very insightful videos. I am mostly interested in Pivot tables and Macros. If you could give me a list of your videos which are supposed to be helpful, that would be great! Thanks..

  • This is an awesome trick. I've tried it a few times but unfortunately I'm getting a runtime error 5. Invalid procedure call or argument???? Any suggestions?

  • This is an awesome trick. I've tried it a few times but unfortunately I'm getting a runtime error 5. Invalid procedure call or argument????

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more