Hi, I need to copy a row from a worksheet and paste it into the next available row on another worksheet in the same workbook. There are a only going to be a maximum of 100 records and the user can do the whole lot at the same time. I need this function so that late comers can be added.

I was going to put a button on every row i.e 100 buttons but Im not sure if thats the way to go.

Help and advise required please.