How to sort data from one worksheet into other worksheets?
 

Hi! I am making an Excel workbook in which we can keep and assign tasks to
various staff. I have one main worksheet, in which we will be assigning the
tasks (using a drop-down list in the C-Column). I want to create other
worksheets for each staff that shows only the task(s) row(s) from the main
worksheet that is assigned to that person. Does anyone know of an easy way
to do this?

How to sort data from one worksheet into other worksheets?
 

I take it that Column C has the staff list (in each drop-down). One way
would be to sort the table by Column C. This would put all the tasks for
each staff member in a group. Copy/paste from there to the individual
sheets. You can also automate this with VBA code. Post back if you want to
try automation. HTH Otto

"Andrea" wrote in message
...
Hi! I am making an Excel workbook in which we can keep and assign tasks
to
various staff. I have one main worksheet, in which we will be assigning
the
tasks (using a drop-down list in the C-Column). I want to create other
worksheets for each staff that shows only the task(s) row(s) from the main
worksheet that is assigned to that person. Does anyone know of an easy
way
to do this?