IF make new row formula and some other questions

[Psnelle]

Hi all,

I'm cryptotrading for some time right now and I want to make an excelsheet where I can register all my trading profits/losses. I am well underway now. I want to register how much coins I buy against which price and my stoploss limit (when the coin sells). On the right side of the table you can see the colomn 'vast' (or sold) and 'ja' and 'nee'. I want to design it so that when I chose 'ja' (or yes) excel automatically opens another row below it with the same coin and transactie (or transaction) 2. So I can put in the sheet against which price I rebought the coin. Can anyone help me with this? And also other tips in making it more usefull would be very much welcome!

greetings,
Pieter

[JohnTopley]

You will need VBA if you want to insert rows.

[shank_mis]

Can we show values on the right side of table instead of inserting a row below when you select "ja" ? That could be done.