Basically what I am looking to do is sort this work sheet by who the file is tasked to. Then I want to pull out certain people with tasks and paste those tasks to a new sheet, a seperate sheet for each person.
The tricky part is that I don't need all of the individuals on the report, just certain ones.
Worse case, I could write a new Crystal Report to only pull the tasks for the individuals I need, but that can be a large pain for seperate reasons. Here is a sample of the data I need to sort. The tasked by is in Column C.
So for a quick example, say there is 10 unique values in column C -- I only want to pull say 3 of those people with tasks to them, have them sort, and each persons task post to a new sheet in excel.
Thanks for any guidance (I have good programming knowledge, just not with VBA or Excel)