Need an add row button that copies specific columns into the new row

Hi,

I have an idea how I'd like to create my form but it's execution is beyond my current skill level, so I need some help, if it's at all possible.

I would like to add an add row button that copies specific columns into the new row. I'm thinking the best way to create this form is to hide all but the first two rows, so that they see all of the headings and the first entry row and then have a button that allows them to add more rows (preferably being able to add +1, +10 & +100 rows to make it easier for those with hundreds of entries).

Column B, C and E are going to be prefilled for each organisation and Column I, M and U all have formulas to make it easier for them, so they'll need to be copied too, so I would like for those 6 columns to copy into each newly added row. And I'll need all of the pre-existing data validation and drop-down boxes to copy into each new row as well.

Or, if you have a better idea for a smarter alternative solution, I'm all ears 🙂 🙂 🙂

Thanks a million $$$