Link Master Sheet/Child Sheets and updating info real-time both wa
 

Hello,

I need some help/guidance on how to achieve something I have been working on.

I have a master table that has a managers name, department name, employees
name, employees ID number, the employees performance rating, their current
salary, and so on.

I also have 5 different managers (actually I have 190+ but this is for an
example) that need to have individual €œchild€� sheets for each manager that
only displays the employees in their department with the respective
performance/pay information. These probably need to be seperate workbooks.

I need to continually €œrefresh€� each of the 5 managers worksheets with
updated employee information (due to transfers into and out of their
department) and I only want to display employees who are currently in a
manager's department.

I then need to capture a rating and percent increase that the manager
assigns to each of the employees on their spreadsheet.

I am not sure how to achieve this in real-time so that every time the
manager opens their own workbook, that it updates the employees who are
currently assigned to their department. Then the manager completes the
review rating and performance increase amount and saves the spreadsheet and
once they do that, how can I automatically roll that up to the master sheet
where I am tracking all of the employees performance ratings and percent
increase across the company.

I have spent a lot of time looking for ways solve this and put a solution
together, but I continue to have difficulty and thought I could present the
whole problem to the group and see what everyone might come up with.

Ron de Bruin has helped me in the past, so not sure if this is another area
Ron has excellent knowedge in or perhaps someone else.

Thanks in advance for your help and guidance.