Macro/VBA for filtering unique entries and pasting in another sheet

  • Thread starter Thread starter waleed.safdar
  • Start date Start date
W

waleed.safdar

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)
 
As always, post YOUR coding efforts for comments/suggestions. You could
probably use a
for each person in people (where people is a range with the list)
do stuff (criteria1 change for each person)
copy to person sheet
next person

But, do you really need to do this when you can filter or use a pivot table.
 
Back
Top