Hi,
I need to build a report that can look down a list of line managers and determine the employees that sit under them whether directly or indirectly. For example, the CEO may have 5 direct reports and each of those reports have a further 20 reports.
The formula would need to return the names (or unique employee reference number which may be easier) of the 105 employees that sit under the CEO plus himself. Total would be 106 employees listed by name or employee code.
Similarly, if I picked a manager who had 3 direct reports and these 3 reports were not managers, the formula/macro would finish with these 3 names plus the manager himself. So 4 in total.
I'm restricted by company security on what I can upload online but have provided an example below.
Searching for Steve Fowler and from the RESULT column you can see that ALL employees report into Steve Fowler either directly or indirectly asides from James Windpipe & Jimmy Vialli.
<tbody>
</tbody><strike></strike>
If someone has a formula/macro for this I'd be forever grateful. Happy to assume the range starts at A1.
Thanks in advance
Ryan
I need to build a report that can look down a list of line managers and determine the employees that sit under them whether directly or indirectly. For example, the CEO may have 5 direct reports and each of those reports have a further 20 reports.
The formula would need to return the names (or unique employee reference number which may be easier) of the 105 employees that sit under the CEO plus himself. Total would be 106 employees listed by name or employee code.
Similarly, if I picked a manager who had 3 direct reports and these 3 reports were not managers, the formula/macro would finish with these 3 names plus the manager himself. So 4 in total.
I'm restricted by company security on what I can upload online but have provided an example below.
Searching for Steve Fowler and from the RESULT column you can see that ALL employees report into Steve Fowler either directly or indirectly asides from James Windpipe & Jimmy Vialli.
<colgroup><col span="3"></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<strike></strike>
<colgroup><col span="3"></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>
If someone has a formula/macro for this I'd be forever grateful. Happy to assume the range starts at A1.
Thanks in advance
Ryan