I use Excel some but not much with the macros. I did some searching but haven't found exactly the combination I need. I'm keeping track of basketball stats during a game and in column A I have the players. I want to be able to select the player then click on a button when they score 1 point to add 1 point in column U same row, another button for 2 points and add the points to column Q same row, and yet another button for 3 points and add the points to column Y. The problem I have not found out is when the quarter switches to 2 (cell G3), to then put the points over one column to the right. Basically it can increment to the columns by the value of the quarter (G3).
Another button/formula is for player fouls. If the quarter is below 3 to put the fouls in column AA and if it is 3 or above to put in column AB.
Another button/formula is for player fouls. If the quarter is below 3 to put the fouls in column AA and if it is 3 or above to put in column AB.
