Handling and implementing Nested data

Is that any proper way of working around this issue in MS Excel rather than to explore wide world of programming database design as i have asked below:

"I am looking for a data structure to handle and implement a data in relational database having nested fields of SHARES with lists of OWNERS related to each leaf node of the shares. See Model below:

Owners Share Data Structure Model.jpg

The model is representing Two Basic information Share and Owners. Shares are also represented in plain form for calculation purpose. (2592, 24, 40 are the total of shares at respective level)

Best Regards

Even if Excel VBA could handle something like this, I believe you would still need to 'explore wide world of programming database design'. When I see a structure like that, I envision some sort of linked list data structure. VBA can do that (http://support.microsoft.com/en-us/kb/166394) but I'm not sure if Excel VBA can. Even if it could, you would need to modify the class to handle your share list and owners list, especially due to whatever those 'subsets' are supposed to represent.

Pauley

Thanks.... LinkedList was also in my head but I just wanted to be sure to select a proper data structure for this cause.