Sorry, but I really don't understand the requirements, and therefore I don't understand the macros that do the real processing

I jumped in to suggest some VBA functions, etc. about a specific problem that had very limited scope and was VBA & Excel in nature

Without a very clear and very detailed requirements spec, I would not be able to help

The other complicating issue is apparently there are external links and multiple workbooks, which make testing very difficult