Hi, I want to create a form with recurring fields for data entry. If the user needs more formatted lines he/she can click a button which will copy and paste rows at the end of the exisiting data.
Specifics for attached spreadsheet:
Expense form: rows 8 thru 20 reflect repeatable data that will be copied upon button click
Upon button click, row 8-20 will be pasted between row 48 & 49
Upon additional button click rows 8-20 will be pasted between 61 & 62,
etc etc
I tried recording a macro but that always winds up pasting the rows in the same place rather than at the end of the current data
thanks
Bookmarks