Creating Multiple Documents from a single table

Croeske

New Member
Joined
Jun 8, 2017
Messages
1
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!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Croeske,

This could be accomplished rather easily with VBA code if you would be interested in that approach.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top