VBA Loop to Create and Save Multiple Workbooks and also import client names and totals into document

ch0720

New Member
Joined
Mar 12, 2019
Messages
1
Hello,

I am in need of a code to create and save 93 excel client reports and also insert client names and totals into the report (specific cells). I currently have an excel document that is the template report and another document that lists client names and total amounts. I'm hoping there is a code that I can use to merge the client information into the template, create and save a separate report for each client, and save the file under the client name. These template reports will be sent to each client so they need to be separate documents and is why I would like the document names to be saved with the name listed.


PLEASE HELP. I've been trying all day.

Thank you!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,109,550
Messages
5,529,472
Members
409,884
Latest member
Msinmath
Top