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?
|