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.