Hi,
Been scratching my head on this one since morning so would be a
treat if anyone drops a hint! I have a sheet with row headers say
(Task, Responsible, Due Date). I want to create a macro that:
1. Filters the list as per today's date
2. Select each person's tasks that show up
3. Paste the tasks in a separate sheet per person

It works for a small list of 5 people, BUT
The problem is that when you have a long list with around 50 names,
then its tough to record a macro for each person individually. Is
there a way for it to intelligently see how many people's names come
up as per step 1 above and then select each person's tasks to paste in
another sheet?

-wally (with a scratch mark on head of course)