Скачать или смотреть Excel - Bob Umlas Add Sporadic Totals with VBA - Episode 1832

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-...


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...


To buy Bob's book: http://www.mrexcel.com/outsidethebox....
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    • Video 00062 Learn Excel: Add Sporadic Totals