I need to have the sheet search through one predetermined field and move up or down based on a positive or negative number. If it reaches the top or bottom of the first predetermined field, I need it to move up or down into the next field and continue counting. It cannot use the top or bottom field to begin counting. Another option would be to have it cycle within the same field (so, it reaches the top and then begins counting at the bottom, or reaches the bottom and begins counting at the top...like a wheel).
A2 is the identifier (#1). I need A3 to find this in the 0-9 fields in the center (numbers in green). A1 is the counter (#-3). In this case, I need it to count up into the 0-9 fields at the top. If it were a positive 3, it would need to count down to 4 in the green numbers. If it were a positive 12, I would need it to count down and cross into the bottom 0-9 field to find the 3 down there.
The code cannot reference any specific data within the 3 0-9 fields, as the data can change frequently. It has to reference the spots only.
This is really beyond my Excel skills. Any help would be most appreciated. Thank you!
Book4.xlsx
So, I have it set up this way[A3 is the spot I need code for]:
A1 | -3
A2 | 1
A3 | ...?
C2-C31:
0
1
2
3
4
5
6
7
8
9
0
1
2
3
4
5
6
7
8
9
0
1
2
3
4
5
6
7
8
9
Bookmarks