Episode 834 - 3-D Spearing

If you need to consolidate multiple worksheets as I discussed in Episode 832, you can skip consolidate and build a spearing or 3-D worksheet reference. Episode 834 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!