I need to create a report of unique projects in a pivot table.
Is there a way to do it in VBA to do it monthly or more frequently as needed?
I do not have access to the original data except by drilling down.

Any help would be great.
Thanks.