Hallo,
I work In HR and I need to create and view reporting relationships in a table.
For clarification I have attached two tables. Table one entitled Sample Indented Report is a sample of the result I am looking for. Table 2 entitled Positions and their Supervisor positions contains a snippet of a large table that I had generated from an HR Management system. Among other information, it has a column containing unique potions numbers and another column containing their related supervisor position numbers. For instance, the Regional VP position supervises the Regional Excecutive Officer's position which in turn supervises the Regional Dental Officer and the Director of Professional Practice. All these positions would be on the positions column but would also appear on the Supervisor position column beside the positions they supervise. This is the same data required to make org charts but I am looking for a way to display the org chart as a table, if that makes sense.
If anyone can help me figure out a function or VBA code to do this it would be great!
Bookmarks