The objective is to generate letters (Microsoft Word) to customers using excel data (e.g. products, prices). I already have a pretty decent macro (adapted from online) for this purpose with one row of excel data used to populate and generate one letter. In theory, I just need to do a minor tweak the VBA code (not too long/complex) to allow for that but am unsure how to do it (see further context below). This is quite urgent so I would favor those who can complete this quickly (in a few days)
Question: How do I tweak the VBA code to allow the possibility of combining more than 1 row of excel data to populate and generate just one letter?
Background: Currently in excel, 1 row of data is for 1 unique legal entity/subsidiary along with the products purchased and prices. Each legal entity/subsidiary belongs to a group/parent company. There are two scenarios here:
-> Each group has only 1 subsidiary (i.e. 1 row of excel data) - DONE. Macro does this
-> Each group has more than 1 subsidiary (i.e. multiple rows of excel data) - HOW TO DO THIS? (i.e. to combine multiple subsidiaries/excel rows into one letter addressed to the group/parent company)
Potential solution? Not sure how to do this but perhaps I need to use some "conditional if statement" to say that if the Group is not unique/repeated (more than legal entity/subsidiary), then to copy each row of information (corresponding to the no. of legal entities/subsidiaries of the same Group) and put into the 1 letter only (so an additional table with product & prices for each subsidiary) could be appended below.
30 freelancers are bidding on average $110 for this job
Dear client, I am an expert in vba. I can modify the existing code to incorporate the suggested changes. Looking Forward Stay tuned, I'm still working on this proposal.