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