Hi Team,
I have Data in range("A1:D9"), I want to extract Scores and Sixes,
in column h and I. I Know how to get it via vlook up in VBA, My data is huge 1lacks row.
I want the result via vba Dictinary/Collection, Just started learning.
Thanks for your help in Advanc
A B C D
<colgroup><col width="64" span="4" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Result
G H I
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks
Mallesh
I have Data in range("A1:D9"), I want to extract Scores and Sixes,
in column h and I. I Know how to get it via vlook up in VBA, My data is huge 1lacks row.
I want the result via vba Dictinary/Collection, Just started learning.
Thanks for your help in Advanc
A B C D
Name | Score | Fours | Sixes |
Sachin | 45 | 9 | 7 |
Virat | 135 | 10 | 5 |
Rahul | 120 | 8 | 8 |
Rishabh | 109 | 8 | 5 |
Rohit | 111 | 10 | 6 |
Shikhar | 66 | 8 | 6 |
Gayle | 106 | 12 | 5 |
Hardik | 55 | 11 | 9 |
<colgroup><col width="64" span="4" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Result
G H I
Name | Score | Sixes |
Rishabh | 109 | 5 |
Shikhar | 66 | 6 |
Hardik | 55 | 9 |
Sachin | 45 | 7 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks
Mallesh