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.
More Excel 2007 videos at http://www.LearnMicrosoftExcel.com. You can also download and print the free Excel 2007 tutorial and sample files from the site. The course can be used for both self instruction for Excel beginners and those moving to Excel from an earlier version. The course is structured into session and lessons make it ideal for teachers who wish to run Excel 2007 courses. This lesson will teach you how to view, add,r emove and navigate worksheet tabs. You’ll also learn how to change the tab color. Weve used years of experience from our classroom courses to perfect our teaching method which will enable you to learn Excel 2007 in a fraction of the time needed when learning from conventional text books.
How to delete and rename worksheets in Microsoft Excel; learn more about spreadsheet software in this free instructional video.
http://www.mathproblemgenerator.com - How to Subtract Fractions with Uncommon Demoninators. For more practice and to create math worksheets, visit Davitily Math Problem Generator at
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.
This Movie is is a short extract from this months online short sharp monthly. This month we were looking at worksheets. we went through 10 different worksheet examples. Some were easy, some tricky, but all of them were amazing in the way they let you get information from Vectorworks. Worksheets are the most undervalued part of Vectorworks. they are powerful, relatively straightforward to create and edit. You need some training to use worksheets, they are not intuitive. 
Learn how to convert worksheet data to a matrix for Surface and Contour Plots, when x and y values are present in the first column and one of the column lable rows.
More Excel 2007 videos at http://www.LearnMicrosoftExcel.com. You can also download and print the free Excel 2007 tutorial and sample files from the site. The course can be used for both self instruction for Excel beginners and those moving to Excel from an earlier version. The course is structured into session and lessons make it ideal for teachers who wish to run Excel 2007 courses. Weve used years of experience from our classroom courses to perfect our teaching method which will enable you to learn Excel 2007 in a fraction of the time needed when learning from conventional text books.
in Vectorworks 2009 you can drag worksheet columns to re-order them. It used to be easier to re-create the worksheet rather than try to re-order the columns. with Vectorworks 2009 you can drag the worksheet columns to get the order you want.