View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default 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?