I have 2 Excel spreadsheets. One is a report from the accounting system. The other is a blank template form. The information from the Accounting system needs to put on the template form programmatically so it can be replicated monthly.
The accounting report will need to be split in to multiple templates based on Month and Customer so they can be emailed. All the necessary information is in the Accounting Report and will be able to fill out the template.