One Report, create multiple sheets, save each sheet in a seperate excel file

Hi... hope you guys and girls are well.. and perhaps able to help me.

1. I have a report of customers and what they owe the company
2. I want a sheet to be created for each customer (in a simple format)
3. I want to have each sheet saved as 'Client's name' and saved.

At the moment this is being done manually.. lots of clients.. lots of time!

Any help will be helpful..

Thanks
Sam

Maybe:

Please Login or Register  to view this content.

Hi John... Thanks for this: A couple of things:

1. The total of the three columns is not coming up were it should be on all sheets (and if i increase the number of lines the total comes in between)
2. Column F (client name) should not be there in the individual sheets.
Thanks
Sam

Sam: 2. Client Name was on the sample. You don't want it to appear on the Sheets? Can you provide another sample of how you'd like your data to appear.

See attached,.

Maybe:

Please Login or Register  to view this content.

That is brilliant John. Many Thanks.

One last thing, is there a simple code I can add after, so that the sheets are saved as seperate excel files?

Try:

Please Login or Register  to view this content.

I didn't close them so you can check. If you want to close them, just activate the line that is commented out.

Great work. Thanks.

You're welcome. Glad to help out and thanks for the feedback.