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

[ShaneATV]

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 $$$

[#2]

I'm not sure if this is what you want but I made a suggestion to add an entry line for tables:
https://feedbackportal.microsoft.com/feedback/idea/ae0a8991-71fa-ed11-a81c-000d3ae5b6f4
and I created a script to do this as I give in this thread:
https://techcommunity.microsoft.com/t5/excel/table-entry-line/m-p/3921561/highlight/false#M204176
maybe that will help

[#3]

While it's a great idea, it's not what I need for this project, however, the idea allover is fantastic so I'm adding the thread to my favourites for future reference. TY :)