VBA: copy unique-value's rows to a template in loop

[LarissaP]

Hey guys!

I have this recurrent situation at work which I think could be fully automated by a macro, however, being a total newbie, I'm not able to do it by myself. Many thanks in advance for any help given =)

Every week I get a big report which lists the clients of each of our sales people and some data related to that. It has headers and columns A to K, column A being the Sales People names (we have 43 of them).
I also have another file (a Template) which organizes the data in a pivot with some conditionals to make it easier for the sales person to check their results (they can only see their own results!!)

What I need is a macro that:
-Filters the unique values on column A of my report
-Copies the unique-values' rows to the template, updating the pivot/conditionals
-Saves a copy of the updated template
-Does these actions in loop for each unique value


So, I should end up with my Template plus 43 files like my template, each with the data of a sales person.

Could anyone please support?

Cheers!

PS: I use Excel 2007