Finding a cell and adding 1 to a cell in an adjacent column

Closed
aarnold@wanee11111 - Jan 15, 2018 at 04:05 PM
 Blocked Profile - Jan 15, 2018 at 04:10 PM
I am working on a simple stat program to replace a tally sheet we use in basketball practice. I have created a page to choose names and statistics to add. Each player has their own macro button that changes the name cell to the appropriate player. If Smith makes a basket, I click on his macro and his name is typed into A10. On the second page, I have the names of all the players in column 1 and all statistics I want to keep track of in row A. I'd like to create macro buttons for the statistics on the first page. Suppose I want to keep track of made baskets in column 2. Assuming I already have the players name in A10, I want to find that name in A1 on my stats sheet and add 1 to the value in column 2 (made baskets). Is this possible?
Related:

1 response

If your player name is the left most column, this is possible with Vlookup. Take a look here and let us know if you need help:
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1?ui=en-us&rs=en-us&ad=us

It's kind of fun to do the impossible! -Walter Elias Disney
0