Thanks
I don’t think I am explaining good.
I am trying to create macro that will look at yourReplaces_1.xlsm file. Then if it finds anything that matches your column A itwill replace it with column B. Then if it finds anything that matches column Dit will replace it with column E and anything that matches column G it willreplace it with column H. Those are all found in the xlsm file you created.

So, when I run the macro from the file I want to convert “theworksheet will be named input in the file I am converting” it will referenceyour file to find and replace all of those items. I will keep your xlsm file in“C:\midstate”

So then anytime I need to add new stores I can just addthem to the replace_1.xlsm file rather than adding them to the find and replacemacro I am currently using. “It is a pain to add more to the when needed andwhen I leave it will be much easier for others to just add them to the xlsmfile rather than me teaching them how to add to the find and replace macro.Plus I am currently using 3 find and replace macros. One to replace items, oneto replace customer names and the other to replace common names.
I would prefer if it did not ask the person running themacro any questions, just does the task like me other one currently does.

Again, thanks for all the continued help you areproviding.