set hierarchy in excel from data

Microsoft Office professional academic 2...
December 8, 2010 at 06:59:56
Specs: Windows XP
I need to establish hierarchy chart/ report from the data that I have. I have a data of emp Id, name and supervisor and end of contract date. I need this data to reflect on another sheet with hierarchy established and also sorted according to nearest end of contract date.
eg: Ash<Clive<Feb - 31/12/2010. So Feb is reporting into Clive who inturn reports to Ash and Feb is finishing the contract on set date.

If at all there are other associates reporting into Ash those names also need to populate under correct designation.

Any help is very much appreciated... Thank you

See More: set hierarchy in excel from data

Report •

December 8, 2010 at 07:12:27
You are going to have to be a lot more specific regarding what you are looking for.

More examples of input data and the desired output would really help.

Keep in mind that we can't see your spreadsheet from where we are sitting nor can we read minds. What you can see and understand so clearly, is completely hidden from us.

Before you post any data, please read the How To referenced in the following line. Click on "How To".

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •
Related Solutions

Ask Question