Hello.
I'm currently working on a file as a way to learn excel and brush up on some skills. However I have gotten to a point where I need help. I have two sheets I am working with. Sheet1 has two buttons. One is "Win" and the other is "Loss". When selecting the "Win" button, I am wanting to have it send a + 1 to a column in Sheet2. The information that is displayed on Sheet1 in a specific cell is what I'm hoping to have show in the correct row of the selection. In case I haven't been able to explain what I am doing. This is the example.
Sheet1
D21:G21 is where the VLOOKUP is . The formula used is:<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Verdana; color: #000000}span.s1 {color: #008f00}</style>=VLOOKUP(Sheet2!A2:A349, RANDBETWEEN(2, 349))
The column in which the + 1, according to what is present in D21:G21, is G2:G349 in Sheet2.
I have been trying to achieve this using VBA, however my VBA skills are on a beginner level at this moment. The most I have been able to do is record a macro and then assign. But doing that with this is showing to be a bit more difficult. It is probably simple but I keep coming back to it and give up.
Thank you for the help.
I'm currently working on a file as a way to learn excel and brush up on some skills. However I have gotten to a point where I need help. I have two sheets I am working with. Sheet1 has two buttons. One is "Win" and the other is "Loss". When selecting the "Win" button, I am wanting to have it send a + 1 to a column in Sheet2. The information that is displayed on Sheet1 in a specific cell is what I'm hoping to have show in the correct row of the selection. In case I haven't been able to explain what I am doing. This is the example.
Sheet1
D21:G21 is where the VLOOKUP is . The formula used is:<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Verdana; color: #000000}span.s1 {color: #008f00}</style>=VLOOKUP(Sheet2!A2:A349, RANDBETWEEN(2, 349))
The column in which the + 1, according to what is present in D21:G21, is G2:G349 in Sheet2.
I have been trying to achieve this using VBA, however my VBA skills are on a beginner level at this moment. The most I have been able to do is record a macro and then assign. But doing that with this is showing to be a bit more difficult. It is probably simple but I keep coming back to it and give up.
Thank you for the help.