Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Wednesday, June 03, 2009

Generalize Recorded Macro - 1028 - Learn Excel from MrExcel Podcast

While yesterday's podcast was created with the macro recorder, you can switch over to the VBA editor to change 4 lines of the macro. This will create a macro that will work without requiring you to rename the pivot table. Episode 1028 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,