MrExcel’s Learn Excel #730 - Insert Worksheets
Thursday, September 10th, 2009
J.B. needs to create a new worksheet for every customer listed on the summary worksheet. He asks if there is an Insert Worksheets command. While there isn’t, you can create one with a few lines of VBA code. Episode 730 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!
Duration : 0:3:27
Rather than create an invoice worksheet from scratch, download a free one from Office Online. Episode 742 will show you how.
James asks how he can combine data from all rows of all worksheets into a single worksheet. 11 Lines of VBA code will do the trick. Episode 636 shows you how.
Rod sends in today’s question. He has to export several tab-delimited text files for a third-party application. He has the data for each file on a separate worksheet in a workbook and would like a macro to save those worksheets as individual text files. In Episode 894, I record a simple macro, then edit it to solve Rod’s problem.