Sample TAble.xlsm

Dear all.
I have a simple macros help request. Im only good at recording, but some stuffs is simply impossible to record.

Ok. so the request is in the attachment.

Firstly, there will be a fixed button in the excel template.
The macro will run once, every time you click the button

1)If you click the button >
2)the macro will select the entire row which has LOWEST in the D column (in this case, row 12)
3)the macro will select one row below that row (in this case, row 13 or 12+1)
4)the macro will right click
5)the macro will insert copied cell in row 13 or 12+1.

and thats it.

A second macro, is all the above, except it will always copy row 1 (but it will paste in the latest row +1 just like above)

thank you!