Hi all, this forum has been of immense help to me this past year with work spreadsheets and I can normally search posts for an answer and edit it to suit my needs, the first time I decide to do something recreational I find I need a specific macro and although i can do basic formulas, macros are definately not something I grasp easily.
I have created a golf syndicate score sheet that works out our handicaps from stableford score entry, for convenience I would like to enter player 1 score at cell A1 on sheet 2 and have that value paste automatically into the next available empty cell on sheet 1 column B after cell B7, once I have the code for the first player I will edit as necassary to bring the other 14 players scores in to play. Thanks in advance for any help given.