Excel - Bob Umlas Add Sporadic Totals with VBA - Episode 1832
2,713 views · Published 3 December 2013 · 4:42 · Indexed 4 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Add Sporadic Totals to Chaotic Data with VBA | Excel Outside the Box Techniques. Welcome back to the MrExcel netcast! In this episode, we have a special guest, Bob Umlas, who is the author of the book "Excel Outside the Box: Unbelievable Excel Techniques". This book contains 54 amazing techniques that will take your Excel skills to the next level. You can find the link to purchase the book in the YouTube comments below. In this video, Bob will be showing us how to use VBA to add sporadic totals to chaotic data. This may seem like a complicated task, but with Bob's technique, it can be done in just one statement and is also very efficient. You will see the results instantly, as Bob demonstrates in the video. To understand how this works, Bob breaks down the data into "chunks" or areas with a certain number of columns and rows. By using the "chunk" function in VBA, he is able to work with each piece of data individually and add the necessary totals. This technique can be applied to any type of data, making it a valuable skill to have in your Excel arsenal. Bob has been a Microsoft Excel MVP for a long time and has a wealth of knowledge and experience in using Excel. In the coming weeks, we will have more podcasts from Bob, so make sure to stay tuned for more amazing Excel techniques. Don't forget to check out the link to his book in the YouTube comments below. Thank you for watching this episode of the MrExcel netcast. We hope you learned something new and valuable from Bob's technique. If you have any questions or suggestions for future episodes, please leave them in the comments section below. Don't forget to like and subscribe to our channel for more Excel tips and tricks. See you next time for another netcast from MrExcel! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Using VBA to add totals to chaotic data. (00:36) Explanation of the VBA solution. (02:17) Step-by-step breakdown of the VBA code. (04:19) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Analyzing data in VBA Assigning Macros in Excel Bob Umlas Chaotic data Excel outside the box Unbelievable Excel Techniques Learn Excel from MrExcel podcast episode 1832 Microsoft Excel MVP and Bob Umlas Put in Totals with VBA Resizing cells in VBA Subtotals in VBA Summing rows in VBA Using chunks of data in VBA Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153656/ To buy Bob's book: http://www.mrexcel.com/outsidethebox.html Today, a guest appearance by Excel MVP Bob Umlas. Say you have random chunks of data and need to add a total to each chunk. Bob shows off a clever VBA solution that adds the totals in almost one line of code. Bob is the author of Excel Outside the Box. If you want to solve this problem without using VBA, see Kevin Lehrbass's video at http://youtu.be/5gPd4z-rK3Y
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920