Merge two text files with given file location in multiple rows in Sheet1 and save the file in another folder with the given name in column C rows respectively.
Example:
Cell A2: a text file1 with the given file location
Cell B2: a text file2 with the given file location
Cell C2: a random given file name
With VBA merge text in Cell A2 with Cell B2 and save the file with Cell C2 given file name in a folder location given in Cell D2.
The next cell is A3, B3, C3
Some rows may have missing data
Bookmarks