Add rows and text to generated data. Macros?

Data.xlsx

Hello All,

I have attached an excel file that I hope someone can help me with.

I've added comments in the cells of the attachment to further clarify, but here are the basics:

In order to import the data to our accounting software we need to have certain data added to each transaction line (in red). With each transaction a new row must be produced above and below each original transaction and text added above the original of "TRNS" and below the transaction of "ENDTRNS".

Ideally, I would like to have these added and a function to replicate all transactions to the end of the sheet.

I have a sense that this would require Macros, but I'm not sure.

Thank you very much.

Hi Arlu,

Ideally no, in the example I sent, no "cheque" text would be inserted in B3. If I were to create what I wanted for row 4, there would be a "cheque" text in B4 & B5, but not B6.

That would be amazing. In a perfect scenario the original data in Row 4:
A new row would be added above Row 4 and replace the SPL with "TRNS", keep the "cheque", keep the same date, replace the text in D with "1000.1 · Total Trust:1007 · Coast Capital - Trust" and finally take the negative value of the value in E4 (170).

Wow, that's all I can say. It worked and I'm extremely grateful.

Thank you so much for your time and expertise, you are amazing.