zendog1960
Active Member
- Joined
- Sep 27, 2003
- Messages
- 459
- Office Version
- 2019
- Platform
- Windows
I have 2 Lists of Numbers ranging from 0 through 36. No numbers will be above 36. The numbers in E2:E7 are in Category A while the numbers in F2:F15 are in Category B. Any number not in those lists would be in Category C.
I input the numbers down column A with the Categories in columns B,C, and D. That's the way they want it. As I input the numbers I would like an "X" to be place in the appropriate column.
I can do this with formulas but there could be hundreds of numbers going down in column A. As you know, the more formulas there are the larger the file size.... ugggg
So anyway, I can do some beginner stuff in VBA but this has my head in a knot. Is there a sub I can use to make this happen or a custom function?
Any help with this would be super appreciated.
Being retired and getting older, I fear I have forgotten for more than I know about vba any more. .
So in a nutshell.....
HELP!!!
I input the numbers down column A with the Categories in columns B,C, and D. That's the way they want it. As I input the numbers I would like an "X" to be place in the appropriate column.
I can do this with formulas but there could be hundreds of numbers going down in column A. As you know, the more formulas there are the larger the file size.... ugggg
So anyway, I can do some beginner stuff in VBA but this has my head in a knot. Is there a sub I can use to make this happen or a custom function?
Any help with this would be super appreciated.
Being retired and getting older, I fear I have forgotten for more than I know about vba any more. .
So in a nutshell.....
HELP!!!
Testing.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | No. | A | B | C | A | B | ||
2 | 2 | X | 8 | 0 | ||||
3 | 11 | 1 | ||||||
4 | 17 | 2 | ||||||
5 | 20 | 4 | ||||||
6 | 26 | 9 | ||||||
7 | 29 | 12 | ||||||
8 | 13 | |||||||
9 | 16 | |||||||
10 | 21 | |||||||
11 | 24 | |||||||
12 | 25 | |||||||
13 | 28 | |||||||
14 | 33 | |||||||
15 | 36 | |||||||
Helper |