Copy value from sheet 2 to next blank cell in sheet 1 [Closed]

Report
-
Hello,
I have a worksheet that works out golf handicaps from the score entered, what I need is a macro that copies the score from sheet2 A1 to the next empty cell in column B sheet 1 (from B7 down). Each week a new score will be entered in sheet2 A1 and needs to be copied to the next blank cell in column B sheet1. Thank you.



Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!