Creating Multiple Documents from a single table

[Croeske]

Hello and thanks for the help.
I am trying to take a ton of sales leads and create a number of documents that we will send to each of our companies branches. The issue is that since they are sales people we can't send them each others leads because they will absolutely poach them. Is there a way for excel to create a new document for each of the different branches if there is a table header for branches other than just copying and pasting into a new document?

Thank you for any help you can provide!

 

[frank_AL]

Croeske,

This could be accomplished rather easily with VBA code if you would be interested in that approach.

 

[Fennek]

Hi,

if the report is created as a pivot-table, it is possible to split the data for each filter to another sheet. Have a look to the options.

regards