Show a Month - 1163 - Learn Excel from MrExcel

Shaun has a large worksheet with 12 monthly reports on it. On a summary worksheet, he would like to show one particular month based on a dropdown. In episode 1163,discusses Paste Special Column Widths, Array Formulas, Match, and OFFSET.

...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!