The starting point is a report in Excel that groups data by customer in rows as attached (I can't change this), each report (monthly) has a different number of transactions per customer and therefore number of rows and what I hope to do is email the data per customer to that customer.
The format of the report is as attached with each discrete data set defined by a cell in Column A which has an account code, a comma and then the company name. The immediately following rows have the transactional details which I need to email, the email address for each account would be held in a separate sheet as attached.
I am seeking to build a macro driven sheet that this data would be pasted into with simple controls that send each customer's subset of data to the appropriate address but am unsure of the best methodology to do this. The nuisance is that there are about 60-70 customers so am seeking the lowest manual input and computational load for the finished sheet.
Any thoughts as to how to design a sheet to accomplish this would be much appreciated, I have some Excel macro experience but not as much as I need to complete this. The account code and company name does not change and I don't mind sending a mail with no data if a company has no transactions for the month.
TIA for any help!
Bookmarks