Extensive Tree Structure

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:

Please Login or Register  to view this content.

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.

Try this macro

Please Login or Register  to view this content.

It's not very efficient but it should get there in the end.

The attached formats the output a little differently, but accommodates arbitrary depth. It does 10K names in about 3s.

The Sort object does not exist prior to Excel 2007, hence the error.