I have a scenario where I have many employees assigned to a cost center and that cost center is part of a org unit. I am in charge of planning for both the org units as shown below. I should be able to see the Excel input schedule as shown below.
the same input shceudle would be used for other managers ( the input shcedule display their respective cost centers, orgunits and employees). When entering data for empl 1, it should update only org1, cost1, 2011.jan for emp1 and not the rest. Is it possible to achieve the same?
ORG1 COST1 EMP1 (x)
ORG2 COST2 EMP3