Paste data to next available empty row

[Barney]

In a spreadsheet used to total golf scores and calculate Stableford points,
the data entry people enter the 18 hole scores for each player. The total
score and points are calculated and the data entry person passes those two
items to the scoreboard on paper. The data entry person then clicks a macro
button on the spreadsheet which copies the input data and pastes it
elsewhere on the sheet. i.e. in row 35 columns B thru Y. The macro also
clears the data and saves the spreadsheet. Now the data entry person starts
another series of inputs. My question is how do I make the next input paste
one row lower each time the macro is run. i.e. row 36, then row 37, 38 etc?

Thanks for your help,

Barney

 

[Ron de Bruin]

Maybe this will help
http://www.rondebruin.nl/copy1.htm

 

[Barney]

I am a little confused as to exact what to do with your code. I think I
will go back and start with your web site "Getting Started....". I am okay
when just recording a macro. Beyond that I get lost pretty quickly.

Thanks for you help.

Barney