Hi
Here's a start.
1) Create a new workbook, and in a general module enter the code
Save this workbook, and keep it as your main controlling workbook.
2) Open your 2 text files (file-a and file-b in your post)
3) Make sure that you are in the directory / path that you require for the output files (ie go file, open, change the path directory, then close without opening a file). This could be incorporated into the macro if required, or made the same place as the main controlling macro file.
4) Run the code. This will create your small split files, and rework file-b to bring in the new entries. Note that file-b will not be automatically saved - this could be incorporated in the code when you are confident that it is actioning correctly.
See how it goes.
rylo
Bookmarks