stevedjswitch
New Member
- Joined
- May 20, 2015
- Messages
- 10
Apologies if this is a duplicate, but I couldn't find this exact question asked elsewhere;
I have a worksheet which shows standard organisational hierarchy, i.e. a column of employees and a column with their unique IDs, plus a column which shows their managers' ID (each manager ID is also an employee).
I also have a column which shows for each employee their employment percentage or FTE (full time equivalent) - i.e. full time = 100%
What I'd like to do is display the total sum of FTE's that each managers has within their control, both directly reporting to them, and indirectly, through people who report to them, who also manage people. There's no max to the number of potential layers.
I can get to a count of employees per manager through a UDF which sets up a recursive count, but something similar which will carry out a sum function is eluding me.
I guess another UDF would probably be the best option, but if there's a non-VBA version that works better, I'd be keen to hear it.
I have a worksheet which shows standard organisational hierarchy, i.e. a column of employees and a column with their unique IDs, plus a column which shows their managers' ID (each manager ID is also an employee).
I also have a column which shows for each employee their employment percentage or FTE (full time equivalent) - i.e. full time = 100%
What I'd like to do is display the total sum of FTE's that each managers has within their control, both directly reporting to them, and indirectly, through people who report to them, who also manage people. There's no max to the number of potential layers.
I can get to a count of employees per manager through a UDF which sets up a recursive count, but something similar which will carry out a sum function is eluding me.
I guess another UDF would probably be the best option, but if there's a non-VBA version that works better, I'd be keen to hear it.