Summarizing Worksheets

D

Don

I have multiple worksheets. Each worksheet has a list of employees and one of three possible shifts. I would like to create a summary worksheet that has three columns, one for each shift, and the names of all employees that work that shift.
 
F

Frank Kabel

Hi
could you provide some more detail about your data sheets (some example
rows as plain text?)
 
D

Don

Each worksheet has three columns as follows
ShiftType EmpName ShiftTim
A joe 8:00-3:0
B mary 11:00-8:0
A fred 8:00-3:0

I would like to create a summary worksheet that looks like
Shift A Shift
joe mar
fre

and any other employees from all other worksheets.
 
Top