MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 258|Reply: 2

Create Org Chart Mgmt Levels from Table

[Copy link]

1

Topics

1

Posts

7

Integral

Newbie

Rank: 1

Integral
7
Post on 1-16-2017 11:27:04 | All posts |Read mode
I have a listing of 500 employees with one data field that gives the next reporting manager by name but not employee number. Ultimately there are up to six levels of management to get to the Regional manager. What query or structure could I use to create a management hierarchy which will identify the Regional Mgr as Level 1 and all subsequent managers perhaps down to level 6 for every single employee in separate fields. Some intermediate management will obviously only have a few names and not all the way down to Level 6.
Example below is what i would like where only the first three columns plus last field for immediate reporting mgr is the data i start with but want to add data fields called Level1, Level2, Level3...etc.
Can't share data due to confidentiality.
Reply

Props Report

2

Topics

36

Posts

108

Integral

Conqueror

Rank: 3Rank: 3

Integral
108
Post on 1-25-2017 00:23:47 | All posts



You can use the table and export the data to Microsoft Org. ,or Excel org charts.
Each person has a Manager field.  Then you loop thru the list ,blank managers are on top.
Then those with that manager are put beneath him., etc.
It's been a while since I've built it,but I will look for the code.




Reply Support Opposition

Props Report

2

Topics

36

Posts

108

Integral

Conqueror

Rank: 3Rank: 3

Integral
108
Post on 1-25-2017 01:35:40 | All posts



You can use the table and export the data to Microsoft Org. ,or Excel org charts.
Each person has a Manager field.  Then you loop thru the list ,blank managers are on top.
Then those with that manager are put beneath him., etc.
It's been a while since I've built it,but I will look for the code.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-18-2017 04:54 , Processed in 0.172022 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!