Hello guys,
I'm new to Excel VBA.
I have an excel sheet which contains list the data like City, Country, State etc. in Column A & B. I was trying to populate the data in column C automatically with the Hierarchy.
Example :
[TABLE="border: 1, cellpadding: 1, width: 500"]
A
[/td][td]B
[/td][td]C
[/td][/tr][tr][td]Parent
[/td][td]Child
[/td][td]Hierarchy
[/td][/tr][tr][td]California
[/td][td]Los Angeles
[/td][td]2
[/td][/tr][tr][td]USA
[/td][td]California
[/td][td]1
[/td][/tr][tr][td]Los Angeles
[/td][td]Universal Studios
[/td][td]3
[/td][/tr][tr][td]New York
[/td][td]New York City
[/td][td]2
[/td][/tr][tr][td]USA
[/td][td]New York
[/td][td]1
[/td][/tr][tr][td]Tokyo
[/td][td]Hamura
[/td][td][/td][/tr][tr][td]Japan
[/td][td]Tokyo
[/td][td][/td][/tr]
[/TABLE]
Can anybody help me with this? I couldn't able to automaticaly populate the data in Column C. I have huge list of data in the spreadsheet. Manually updating this task is tedious .
Thanks in advance.
Veda