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.
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.
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. th-cam.com/video/txd6mEGVBeI/w-d-xo.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.
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.
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.15 (1/4)](http://i.ytimg.com/vi/TLBjiHvkKtE/mqdefault.jpg)
one best VBA tutorial channel
Great teaching method! Well done! Thanks for your efforts!
Thank you for these useful tutorials
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.
Great tutorial, earned my sub!
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.
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.
th-cam.com/video/txd6mEGVBeI/w-d-xo.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.
Really nice video
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.
Sir make code for
if Cell contain value greater than 0 then cut entire row into another sheet
Hi there, Thanks for your question. I've uploaded a video for this now. th-cam.com/video/iLckSTpE7DE/w-d-xo.html
There is nothing in 25 minutes video, it should be 3, 4 minutes