Master sheet updates and sub sheet automatically update as well

**charscribbles** · 07-02-2014, 09:24 PM

Hi, this is my second time posting but I haven't gotten any good advice yet. Hopefully someone can help me out on this one.

Currently i have a few sheets, one being "Employee Data" with 6 headers: Dept | SAP ID | Full Name | Classification | Position | Location
In the other sheets I have every department's quarterly report.

What i want is the code to automatically search the employee data sheet, find the specific department name in column A, and find the staff names in the department in column C, and automatically input the staff names in the particular department sheet.

When new employees are added into the employee data sheet, the code will detect and update the names on the particular department sheet as well.

Is there any code that can do this?

Please help

Regards,
Charmaine

**dubcap01** · 07-02-2014, 09:27 PM

Charmaine,
Can you provide a spreasheet with what you would like it to look like? Doesn't have to be the real one, just a dummy one

**charscribbles** · 07-02-2014, 09:42 PM

Hi Pete,

Thank you for the quick reply. With attached is the exact file I'm working on. You would just have to look at "Employee Data" & "315" sheet as an example.

In employee data sheet, looking at column A and C, i want to detect the people in only "315 - service / workshop" department and paste the names in "315" department sheet starting from B12 onwards.

Regards,
Charmaine