I want to create a button that when clicked will copy specific rows and paste them at the end populated records.
Specifically, I have a document to record expenses... there are a set of questions (rows 8 -20) that will initially be repeated 3 to 5 times. IF the user needs more than these, then he/she can click the button and one more additional set will be pasted after the last set of questions (but before the button). In the attached spreadsheet, it would mean that the additional rows are pasted between lines 48-49. Upon a second button click, the lines would be pasted at approximately 61-62, and a third click at approx 74-75, etc etc
I tried recording a macro but that pastes the rows in the same position rather than at the end of the data.
any help would be appreciated.
file attached
thanks
Bookmarks