Hello,
To be honest, I'm not sure if I'm even using the correct words here so that might be why my google-fu is failing me.
I have a flat file that contains a organization. For each person you have that person's group's ORU (Organizational reporting unit) and their manager's ORU. With that, you should be able to build up an organizational hierarchy.
A the end of the day(or week the way this is going), I'd like to be able to select ORU 10 by then have all of the ORU below it be returned so that I can, say, add up all of the costs for an Organization (IE, so me all of the CIO/IT costs. So, IT Guy USA, IT Gal China and IT intern China since they both report into the CIO.)
Any pointers as to where I should be starting?
I'd prefer Excel or PowerPivot type stuff vs VBA.
Thanks!,
Alex
ORU Mgr | ORU Person | Person
----------------------------------------
1 | 1 | CEO
1 | 10 | CIO
1 | 11 | HR Manager
10 | 12 | IT Guy USA
10 | 13 | IT Gal China
11 | 20 | HR Person
13 | 30 | IT intern China
Bookmarks