Auto populate formulas and borders when rows are inserted into database

Hi All

Is there a way for me to auto populate a row with the previous rows formulas when new info is populated form a database.

In attached Worksheet, if I Press on PAYMENTS icon in Database Sheet, and I process a payment, the info gets sent to Payment transaction history Sheet.

Is there a way for me to auto populate a row with the previous formulas when new info is populated form Database Sheet.
The rows inserted could be ongoing and if I need to print out the sheet, I don't want to print out all the blank rows etc.

I have been searching options all day, even had a look at tables.

Any suggestions.

Hi FDibbins

Thanks for your reply. I have looked at that option but the records could go on forever and I will not want to have Table that large.
Is there a way to insert as we go along or am I looking at the Tables format incorrectly.

Hi FDibbins

I converted to a Table and it worked succesfully. I will write code to hide balance of rows before printing.

Thanks for assistance.