Tuesday, July 12, 2011

Create excel macro variable off of search?

I am trying to create a excel workbook that has 3 sheets. The first sheet has a multiple players name and a button next to each name. The second sheet has buttons such as 2 points, or rebound, that when you click on them will add 1 to the third sheet which is there actual stats. The third sheet contains a database that has columns of name, points, rebounds. I want the first macro on the first sheet next to name to take you to the second sheet which you will then choose a category. It uses the variable name to then insert the data on the third sheet in the correct row. What would be the macro to search the third sheet until it finds the row that has the right name and then adds the data?

No comments:

Post a Comment