Populate Unique Values to Different Sheet

[BryanPayne]

Hello everyone!

I am creating a workbook that will have a Data tab that will have all of the time-sheet data from all of the employees time-card punches. What I am wanting to do is click the Sort Employees button and have each employee copied from the Data tab and pasted to their respective spreadsheet that's listed by department with a Unique Value only.

Here is the PrepareData tab: (with all of the other named tabs below)


This is the 66-Inc tab that will show how I want the data to format once pulled from the Data tab: (Beverly and Cynthia are the only employees that belong to this department)


Here is how the Data exist on the Data tab:


Any help is appreciated!

 

[RobertSF]

We can't see because your photobucket account has apparently been disabled.