Dear Experts,
Please refer the attached excel file.
With the help of existing VBA codes, we are trying to derive no. of combinations for given sizes & then some calculations are made.
If there are many sizes or the smaller sizes are there then the no. of combinations reaches to some thousands / lakhs.
To reduce the time is it possible (instead of populating the data in excel cells with given VBA codes) to make all the entries & calculation in Scripting.Dictionary then just paste the data as shown in attached file.
Please suggest.
Thanks in advance....
Add in Directory.xlsm
Bookmarks