VBA Script in Excel 365 to add a new row when a button is pressed

When you say table do you mean an Excel Table (when you click on a cell in the table a new option at the top should appear, Table Design) or is it just some data that you have put borders around?

I am guessing its the latter and recommend you format the data as a table. To do this select the data area (including headings) and then hit Ctrl+T. Tick the 'my data has headers' box if not already then click ok.
When you add any data underneath Excel will resize the table for you. Any columns with formulas will automatically copied down along with conditional formatting.

It will be best to start on a blank sheet and copy paste the data in that you have (as values) an add formulas conditional formatting so that they auto populate.
If you need help any help with creating let us know.