And no mention of Heidelberg KKB, VBC HB, or Indepentents

Oh well, more files to download and research

OK, you have a different Replace file for each Distributor and for Invoices and Returns for each Distributor.

Do any Distributors have any matching Store names or product Identifiers? IOW, why can't I consolidate all the Replacements into two Tables, one for Store Names and one for Products.

I just did a quick visual analysis of all the Product Replacements in one list and while there are a lot of duplicates, many just seem to be from inserting an asterisk in the Returns Replacement Product names.

I repeated that with the store replacements and... Holy shit... I'll need to consider them on an individual basis.

The difference in speed between pulling replacement values from one Dictionary and a gazillion sheets is phenomenal.