Math Student Help

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

(more…)

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 blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Duration : 0:4:29

(more…)

http://www.ExcelVisualBasics.com - Tutorial on how to export worksheet data in your Excel worksheet to a file on your hard drive like a notepad file, a text file, a wordpad file, or even other file types. You can export an Excel workbook in this fashion.

ExcelVisualBasics shows you visually what vb code actually does BEFORE you waste your time trying to tweak it.

Duration : 0:6:53

(more…)