I have found the script masamiki.com/project/export-hierarchy-to-excel.html to export to excel which is great as most the people dont have Project on their PC.

What I would like to do however is to be able to create on sheet per resource so they can effectively be handed out to the individual people.

Whilst I can filter tasks what I seem unable to do is to then work with that subset of tasks as after filtering the VBA still uses the complete set.

I am sure this will be an inefficient way to do it but it wont be used often so shouldnt be too bad.

How can I change the ActiveProject.Tasks to be simply the filtered/ currently visible tasks rather than all?

Many thanks