bradenkeith
New Member
- Joined
- May 4, 2014
- Messages
- 32
Hey everyone, I'm in need of some vba assistance.
<tbody>
</tbody>
<tbody>
</tbody>
Considering the visual aids above, here is what I'm looking to accomplish:
I have a spinner that changes the value of Cell A2 by increments of 1, and I have already written the code that pulls the data from Table1 to Cell B2 depending on the value of Cell A2. For example, if I use the spinner to change A2 to "5," then the value of cell B2 will automatically update to "3752." What I need is a string of code that will input data into Table1 (on Sheet 2) based on the value entered into Cell B2 (on Sheet 1). For example, if the value of Cell A2 were changed to 3, Cell B2 would be blank. If I were then to enter "5427" for example, I would like this value to then reflect in cell B4 (on Sheet 2). That way, when I change the value of cell A2 away from and back to 3, It would automatically recall "5427" in cell B2. I hope this makes sense. To clarify, I need to accomplish this with Worksheet_Change. Can it be done?
| (on Sheet 1) | A | B |
| 1 | Game | Points Earned |
| 2 | 1 (variable) | 5368 |
<tbody>
</tbody>
| Table1 (on Sheet 2) | A | B |
| 1 | Game | Points Earned |
| 2 | 1 | 5368 |
| 3 | 2 | |
| 4 | 3 | |
| 5 | 4 | |
| 6 | 5 | 3752 |
| 7 | 6 | |
| 8 | 7 | |
| 9 | 8 | |
| 10 | 9 | |
| 11 | 10 (etc...) |
<tbody>
</tbody>
Considering the visual aids above, here is what I'm looking to accomplish:
I have a spinner that changes the value of Cell A2 by increments of 1, and I have already written the code that pulls the data from Table1 to Cell B2 depending on the value of Cell A2. For example, if I use the spinner to change A2 to "5," then the value of cell B2 will automatically update to "3752." What I need is a string of code that will input data into Table1 (on Sheet 2) based on the value entered into Cell B2 (on Sheet 1). For example, if the value of Cell A2 were changed to 3, Cell B2 would be blank. If I were then to enter "5427" for example, I would like this value to then reflect in cell B4 (on Sheet 2). That way, when I change the value of cell A2 away from and back to 3, It would automatically recall "5427" in cell B2. I hope this makes sense. To clarify, I need to accomplish this with Worksheet_Change. Can it be done?
