Hi All,
I am working on a tool which involves parent-child data.
Considering the two cases below, I need to consolidate data which is rolling up-to my client ultimately in a different sheet through a VBA code. In example 1 below my client is A whose parent is B and B’s parent is C. A has 4 children and similarly E has three children and so on. I need a code through which I can consolidate data of all children ultimately rolling up-to my client. There can be multiple levels of hierarchy involved. Hope I was able to explain myself well.
Scenario 1
Parent Child
C B
B A Client
A E
A F
A G
A H
E I
E J
E K
F L
I M
I N
M O
M P
M Q
Scenario 2
Parent Child
C B
B A Client
A E
A F
A G
A H
E I
E J
E K
E L
E M
E N
F O
F P
F Q
Kindly help to make a dynamic vba code for this one.
I am working on a tool which involves parent-child data.
Considering the two cases below, I need to consolidate data which is rolling up-to my client ultimately in a different sheet through a VBA code. In example 1 below my client is A whose parent is B and B’s parent is C. A has 4 children and similarly E has three children and so on. I need a code through which I can consolidate data of all children ultimately rolling up-to my client. There can be multiple levels of hierarchy involved. Hope I was able to explain myself well.
Scenario 1
Parent Child
C B
B A Client
A E
A F
A G
A H
E I
E J
E K
F L
I M
I N
M O
M P
M Q
Scenario 2
Parent Child
C B
B A Client
A E
A F
A G
A H
E I
E J
E K
E L
E M
E N
F O
F P
F Q
Kindly help to make a dynamic vba code for this one.
