Hi, Do you mean you want to dynamically search for the starting header row? i.e. could be any row 2,3 etc.? i would suggest using the find method. i have a separate video that shows how to dynamically identify any dataset no matter where its placed in the sheet. code can be found here: skillsandautomation.com/how-to/how-to-find-last-row-in-excel-vba-using-find-method/#Example_1_Identify_and_Select_Data_Range
hi there, epic lecture !! feedback: Group array is not woking properly: these appear unmapped ..... Caramelised Onion Relish 400G x 10 Crunchy Peanut Butter 500G x 10 Spicy Mango Chutney 400G x 10
Hi, Sorry for the super late reply. I was away from the channel for over a year in between. This comment must have slipped through. Still thought I will reply for the benefit of others though. I have tried out the code again, and these 3 product codes map correctly for me. e.g. Caramelised Onion Relish 400G x 10 is mapped in the Output Sheet to Condiments & Relish. i.e. If you run the code from the downloaded macro file as-is, no product should be unmapped. If this is not true for you or any other viewer, please confirm. If you have perhaps changed some values anywhere else, and the product codes are unmapped as a result of that, please confirm. My long shot guess is that Excel is acting funny, rather than the code itself. But, i would need more details to know either way.
![Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]](http://i.ytimg.com/vi/D8chnkrNaqQ/mqdefault.jpg)
![Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]](/img/tr.png)
![[LIVE] : ONE ลุมพินี 80 | คู่เอก "รักษ์ vs ยอดนำชัย"](http://i.ytimg.com/vi/ckLMRorsMeY/mqdefault.jpg)
these projects are pro level projects
One of the most usefull video I have ever seen. Thank you.
You took a complicated topic, and made it super easy to understand. THANK YOU!
Very nicely explained about array 👌👌👌👌👌👌
Please do mapping for a cash flow statement example using trail balances
Great. Love it. Can you please prepare the same example using dictionaries?
This is super useful. I have subscribed to your channel.
This is like art, nice
Super helpful! do you have a reference when the IN sheet header is on a different row? Example row 7 is the start of the header
Hi, Do you mean you want to dynamically search for the starting header row? i.e. could be any row 2,3 etc.? i would suggest using the find method. i have a separate video that shows how to dynamically identify any dataset no matter where its placed in the sheet. code can be found here: skillsandautomation.com/how-to/how-to-find-last-row-in-excel-vba-using-find-method/#Example_1_Identify_and_Select_Data_Range
Harika bir sunum. Teşekkürler.
This is an amazing work, thank you so much
Please do more examples
Amazing job brother
hi there, epic lecture !! feedback:
Group array is not woking properly: these appear unmapped .....
Caramelised Onion Relish 400G x 10
Crunchy Peanut Butter 500G x 10
Spicy Mango Chutney 400G x 10
Hi, Sorry for the super late reply. I was away from the channel for over a year in between. This comment must have slipped through. Still thought I will reply for the benefit of others though. I have tried out the code again, and these 3 product codes map correctly for me. e.g. Caramelised Onion Relish 400G x 10 is mapped in the Output Sheet to Condiments & Relish. i.e. If you run the code from the downloaded macro file as-is, no product should be unmapped. If this is not true for you or any other viewer, please confirm. If you have perhaps changed some values anywhere else, and the product codes are unmapped as a result of that, please confirm. My long shot guess is that Excel is acting funny, rather than the code itself. But, i would need more details to know either way.
thanks
Nice Explained Please Zoom the code
Plz share practice file
Hi, I've uploaded the file to Github now. github.com/skillsandautomation/dynamic-arrays-transfer-data