Excel Utility for TXT Export

I need a compact Excel workbook that can take the data I enter and, with one click, generate two separate .txt files for my bank’s bulk-upload system. One file must hold “ONE FILE FOR BANK ACCOUNT ADDING AND SECOND FOR MAKING BANK TRASACTION DETAILS” and the other will hold the corresponding transaction details.

For the account-adding file the bank wants the line to look exactly like this example:

FOR 1ST UTILITY FILE -
S|A|Raj Kumar Gupta 119|37702800961||17081|||
S or O|A|NAME|ACCOUNT NO||BRANCH CODE or IFSC||| - THESE WILL BE TITLES

FOR SECOND UTILITY FILE
50530792760|IDIB000N614|30/09/25||20000|UNIQ_REF_NO|MAHESH CHAND YADAV 119|NEFT
(ACCOUNT NO)|IFSC CODE|DATE|AMOUNT|UNIQUE_REF_NO|NAME|NEFT - - THESE WILL BE TITLES
Their spec explicitly calls for NO SEPARATOR, so every field has to sit in the right position and length—not simply split by pipe, comma, or tab.

Please build all of that logic into the sheet. A macro button (or equivalent solution) should save the two text files automatically, ideally with a date-stamped name so I can run it daily without overwriting previous exports.

Deliverables – precise and testable:
• One Excel file (.xlsm or macro-free if feasible) pre-mapped for the required fields.
• Built-in routine that produces the two correctly formatted .txt files with no separator.
• Brief usage notes inside the workbook so I can add rows or tweak column order later.

I’ll consider the job complete when both exported files upload to the bank portal without format errors.