Reporting back!

The Many-to-One add-in is so complex that a lot of it is flying over my head - my own problem. I will continue to try and figure it out and in the meantime I will use the simpler Merge and Split add-in instead for shorter documents where the clause reference hyperlinks are not crucial.

If you don't mind, I have been exploring your other works (you are a true hero and I appreciate all the work you've done for the community), and have a couple of quick queries on some of them - but these are not urgent at all and they can certainly wait.

1. Multiple Document Merge: I test ran it using your Example Data set and my own data set and found that when I ran the process, the system would constantly prompt me to run the SQL command "SELECT * FROM 'Sheet1$' and then I have to navigate to the folder and select the excel sheet again for each separate document. This means if I have 3 documents for output and 5 datasets, I get 15 prompts and have to navigate to find the excel sheet 15 times. Am I perhaps doing something wrong?

2. Boilerplate: Is there a simple way to remove only one boilerplate from the long list of boilerplates I have created? I tried deleting the reference document in the folder but it continued to show up in the add-in list. I couldn't amend the table in the template document to remove just that one line either. So far I found that I have to (i) delete the reference document in the folder, (ii) reset the whole add-in and (iii) relink the folder so that everything is repopulated without the deleted boilerplate.