Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]

Excel VBA Dictionaries explained in simple terms. Advanced concepts made easy. Unravel the benefits of this awesome tool and take your VBA programming to the next level.
We will cover 4 practical use-cases
1. Find Unique Values from a List
2. Perform Sum & Count on Grouped Values
3. Copy & Paste Data Dynamically
4. Perform VlookUps
#vba #learnvba #excelvba #excel #exceltutorial #exceltips
Dictionaries may be a tough concept to grasp. And that's too bad. Because there are so many great ways to use them in our everyday coding. This video will go get you started with using dictionaries ASAP.
Learn the basics of dictionaries and directly start using them in some useful examples.
All code is available at my blog site:
skillsandautomation.com/usefu...
Course file is uploaded to Github:
github.com/skillsandautomatio...
00:00 Intro
1:33 What is a Dictionary?
2:22 Main Features
3:25 How to Use Dictionaries
9:05 Initial Setup
10:54 Example 1: Find Unique Values from a List
13:02 Example 2: Perform Sum & Count on Grouped Values
17:04 Example 3: Copy & Paste Data Dynamically
21:05 Example 4: Perform VlookUps
23:49 When To Use Dictionaries

[@umesh6600]

one best VBA tutorial channel

[@adamonjourney3726]

Great teaching method! Well done! Thanks for your efforts!

[@janezklun]

Thank you for these useful tutorials

[@tomstrack42]

Great tutorial, earned my sub!

[@shridharsahu8742]

Hello Iam not able to pass a variable for key, it takes the actual variable name as key but not the value it holds, why so please xplain if there is a. Solution.

[@philwhyte4]

Hi there, well done on creating a very informative and educational tutorial. I have now subscribed and look forward to the Dictionaries with Class Objects. Thank you.

[@rakeshthakur9403]

Really nice video

[@Kuldeep100]

Thank you sir for this very good tutorial. I am new to VBA. Could you please advise me in making a use of this tutorial in my personal situation. I have two sheets. Sheet1(target) has a column of account ids. The second column needs to be populated from sheet2(source).Sheet2 has a column of account ids and its respective amounts. I tried to create a sample test by creating a macro based on your fourth part of the tutorial. You have created two separate loops one for countries(source) and another for players(dest). Once the first loop is over and proceeds to second loop, the data from first loop doesn't get carried over to the second loop. As I said, I am a beginner, your help here will be much appreciated. Regards.

[@SkillsandAutomation]

Hi, Thanks for your question.
If data is not transferring, then that means the dictionary isn't populating correctly. I think you'll need to step through the code to see where the issue is.
I will suggest you check out my video on 9 tips to see how to step through code.
ruclips.net/video/txd6mEGVBeI/видео.html
If I had to guess, the column references may need to be checked while populating the dictionary.
Also, I have made a blog post to help you with your query. You can check out the link below.
skillsandautomation.com/useful-code/dictionary-questions-answers/
It has code based on Target/ Source sheet that you have mentioned. I'll suggest that you even try out Nested For Loop to do lookups, as it is easier to debug.
Hope this helps.

[@kaanapadhiyar1143]

Sir make code for
if Cell contain value greater than 0 then cut entire row into another sheet

[@SkillsandAutomation]

Hi there, Thanks for your question. I've uploaded a video for this now. ruclips.net/video/iLckSTpE7DE/видео.html

[@kaushalkumar-fk6xr]

There is nothing in 25 minutes video, it should be 3, 4 minutes