I have a dataset containing data for multiple entities. I need to populate specific cells in an Excel template for each entity. Effectively looping through each entity, populating the template, and saving dynamically with the entity name. I have managed to loop through entities and populate specific cells, but it is creating a brand new workbook for each entity instead of populating the existing template.
Can't post the existing workflow as it contains confidential information, but currently have a batch macro which takes the file path, entity name, value and corresponding cell reference. On the Output tool, I am using the "Take File/Table Name From Field" and using a created field (Output Target) as the field containing file name.
Any help would be much appreciated!
