Create multiple dictionaries on basis of cell values

[ANKUSHRS1]

Dear Friends,

I have data like having 500 cells. I want to create 500 dictionaries with names on basis of value of coloumn B.
Refer below example
I want to create dictionary with name Mumbai, pune, Delhi .. So on..

A B
1 MUMBAI
2 PUNE
3 DELHI

Pls help with vba code

 

[Marc L]

Hi !​

​

Thanks to elaborate what is a dictionary for you, what's the purpose, what's the link with Excel ?​

​