Welcome all.
This project has, privately, gone through multiple iterations over a number of years and it is time I give it to the excel VBA community, and anyone else who could make use of in any way.
The origins of this was born out of a commercial solution written for a client a few years back. The solution consolidate journal entries from an excel workbook to an excel template for uploading to the financial system. All was hardcoded back then, but did the job.
Out of that spawned the idea that a generic solution would allow automation of conditional copy and paste type actions without the need for IT intervention and without end users generating macros that cannot be maintained.
I will apologies for not commenting better and simplifying more, as this was not created with training in mind, and would welcome anyone who has the time to help improve.
There are commercial propositions that may be slicker, but this is open source and allows you to use and customise as your needs dictate. I hope you enjoy…
Updates
Add Copy Worksheet Add-in
User Guide