bradenkeith
New Member
- Joined
- May 4, 2014
- Messages
- 32
I am in need of a simplified code that draws data to a series of cells depending on a particular cell's value. To keep things organized, I will illustrate what I need with the following example and figure out the rest on my own.
Imagine there is a line of infinite persons, each person is wearing a hat of a different color, and the purpose of this exercise is to associate the color of a persons hat with their respective place in line. It seems simple enough; however, I need all information consolidated visibly to two cells (A2:B2).
<tbody>
</tbody>
A spinner will be used to change the value of cell A2 by increments of 1 (from 1 to infinity), and the code I am looking for must draw data to cell B2 upon activating said spinner. All data will be drawn from the following Table ("Table 1"):
<tbody>
</tbody>
The tricky part is that I also need to be able to change Cell B2 thereby updating Table 1 with new information. Can it be done?
Imagine there is a line of infinite persons, each person is wearing a hat of a different color, and the purpose of this exercise is to associate the color of a persons hat with their respective place in line. It seems simple enough; however, I need all information consolidated visibly to two cells (A2:B2).
A | B | |
1 | Place in line | Color of Hat |
2 | 10 | Blue |
<tbody>
</tbody>
A spinner will be used to change the value of cell A2 by increments of 1 (from 1 to infinity), and the code I am looking for must draw data to cell B2 upon activating said spinner. All data will be drawn from the following Table ("Table 1"):
Table 1 | A | B |
11 | Place in Line | Color of Hat |
12 | 1 | Blue |
13 | 2 | Green |
14 | 3 | Orange |
15 | 4 | Brown |
16 | 5 | White |
17 | 6 | Brown |
18 | 7 | Brown |
19 | 8 | Blue |
20 | 9 | Green |
21 | 10 | Blue |
<tbody>
</tbody>
The tricky part is that I also need to be able to change Cell B2 thereby updating Table 1 with new information. Can it be done?