In the thread located here http://www.excelforum.com/excel-prog...ml#post2310968 I asked for a macro that would resolve the tree structure of an organization, showing who reports to who all the way down the chain.
The macro developed worked well for the sample data, and went 4 levels into the structure, providing output like this:However, it couldn't cope with the full data, which has 8 or more levels of management, such as![]()
Please Login or Register to view this content.
The attached spreadsheet has the source data on Sheet 1, and on Sheet 2 a representation of what the output should look like. Any help I can get on getting to the desired output would be greatly appreciated.![]()
Please Login or Register to view this content.
Bookmarks