Let me start by explaining the process of what I am trying to do
I have an original text file and I am trying to build many (about 650) text files with a few minor changes to each one
The changes include renaming each file with a specified file name and replacing some of the words/data in text file
In the uploaded workbook I have laid out two tables on sheet1 and sheet2 that help illustrate what I am trying to do
I have also uploaded the base .txt file that I am using.
Bookmarks