This seems like it should be simple, but I've been struggling with it the last few days:
I have a MASTER sheet, and several other sheets which need to display portions of the MASTER sheet data.
My MASTER sheet has a list of employee names (Column A) and the areas they work in (Column E.) I want to pull a list of employee names (Column A from the MASTER) working in Area1 (sorted Column E on the MASTER sheet) to Column A on the Area1 SHEET, then pull a list of employee names working in Area2 to column A on the Area2 SHEET, etc...
I want it to do this in such a way that if I add an employee to Column A on the MASTER data sheet, it will populate that employee in Column A on the Area1 Sheet.
So basically, I'm looking at one column on the MASTER sheet to see if the area matches. Then looking at another column on the MASTER sheet to get the name. Then taking that name and transposing it to a new sheet corresponding to the area they work in.
I've attached a sample sheet. I want all names on the Master Sheet Column A to appear on the Area1 Sheet Column A that match the Master Sheet Column E Area1. Likewise for Area2, Area3, etc...
Thanks for any help.
I have a MASTER sheet, and several other sheets which need to display portions of the MASTER sheet data.
My MASTER sheet has a list of employee names (Column A) and the areas they work in (Column E.) I want to pull a list of employee names (Column A from the MASTER) working in Area1 (sorted Column E on the MASTER sheet) to Column A on the Area1 SHEET, then pull a list of employee names working in Area2 to column A on the Area2 SHEET, etc...
I want it to do this in such a way that if I add an employee to Column A on the MASTER data sheet, it will populate that employee in Column A on the Area1 Sheet.
So basically, I'm looking at one column on the MASTER sheet to see if the area matches. Then looking at another column on the MASTER sheet to get the name. Then taking that name and transposing it to a new sheet corresponding to the area they work in.
I've attached a sample sheet. I want all names on the Master Sheet Column A to appear on the Area1 Sheet Column A that match the Master Sheet Column E Area1. Likewise for Area2, Area3, etc...
Thanks for any help.