Hi there!

At the company, where I work, the abbreviatons refering to the departments has been changed, e.g. "LOG" to "SCM" (logistics to supply chain management). Plus in some cases, the number-system will change, too: "LOG-003" to "SCM-005". Therefor almost every file, has to be changed. I have an excel file containing the old abbreviations in column A, and the new ones in column B.

The excel files only contain the abbreviations in their footer. I searched the internet for hours, but I couldn't find a macro that could find and replace certain values in multiple excel files' footer from batch. I would be really grateful if someone could help me!!