auto suggest/copy previous filled row value to the next row and allow users to edit the copied value

[Archana_831]

Hi,

I am giving users to fill a table with multiple columns. To reduce their efforts I want to auto copy all the values from editable columns to the next empty row and then the user can decide if they want to edit the copied values or not.

Example:

I want the row value which was filled latest to be copied for Deliver note and Storage location in the all  the remaining rows:

Is there a formula which I can apply for these columns specifically?