Hi, I am new to using macros in excel. This is my first posting in here too, forgive me if it's a bit hard to follow.
I am making up a workbook for my soccer team to record and tally players player points throughout the season. In the workbook each game has its own sheet that calculates the total points each player received for that game. This total is recorded in J33:J52. What i would like is to have a macro that copies J33:J52 of the active sheet, then pastes it into the next blank column of a summary sheet.
So after i've entered all the points for round 1, i would click on the macro button and it would paste J33:J52 of round 1 into A1:21 say, of the summary sheet. Then after i've added in the points for round 2 in the round 2 sheet, it would automatically see that the next blank column in the summary sheet is B1:B21 and paste J33:J52 of the round2 sheet there and so on for each round.
Hope this makes sense.. In essence i just don't know the code for selecting a range that is the next blank column in a sheet.