MrExcel's Learn Excel #981 - Paste Skip Blanks
Gary sends in a clever solution for Episode 977 which uses the Skip Blanks option of the Paste Special dialog. Watch for how Gary can "reverse" the filtered and hidden rows during the steps shown in Episode 981.
This video is the 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!