Setting up Tree Structure

Zbor,

Thanks for trying, but that doesn't do it. For instance, if on the "Reports To" tab I pick Barack Obama, I can see that Albert Einstein, Jack Nicholson, and Weird Al Yankovick work for him, and how many hours they worked. But those three are all supervisors; they each have teams of caseworkers who report to them, and it's those caseworkers I want to see, and the hours they worked.

If my spreadsheet has 20K rows, I need to be able to see it like this:

Biggest boss>Smaller boss>Smaller boss>Caseworker>Hours worked
1 of these 30 of these 400 of these Thousands of these

But thanks for trying.