Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,665
- Office Version
- 365
- 2016
- Platform
- Windows
Consider my database.
br />
I would like to apply a filter to column A based on user selection, either DIA, FLD, or CRT.
This will result in onlt the DIA records exposed.
What I would like to do, is create a list of unique values in column B based on the filtered data. This list will be used in a userform combobox for the user to select from.
Then, using a similar method, this selected value will be then chosen to filter column B. Based on the resulting filtered database, similar code will be used to isolate the unique values in column C, for yet again another combobox.
These pocedures are basically a form of validation, allowing users to only select available selections for relevant choices.
Is this logic appropriate? How would I go about doing this? I am a novice coder, and would welcome any support to accomplish this feat.
Jenn
Excel 2003 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | |||||||
2 | Type2 | Activity | Organization | League | Calibre | ||
3 | DIA | 3-Pitch | WCDSB | St. Davids Boys | SCH | ||
4 | DIA | 3-Pitch | Region of Waterloo | Healthy Lifestyles | REC | ||
5 | DIA | 3-Pitch | WCDSB | St. Davids Girls | SCH | ||
6 | FLD | Soccer (Atom) | WMSA | Atom | HL | ||
7 | FLD | Soccer (Atom) | Misc. | Atom | REC | ||
8 | FLD | Soccer (Atom) | KW Soccer | Atom | REC | ||
9 | FLD | Soccer (Atom) | Grand River Soccer | Atom | REC | ||
10 | DIA | Baseball | WMBA | Bantam | HL | ||
11 | DIA | Baseball | WMBA | Bantam | REP | ||
12 | DIA | Baseball | Misc. | Bantam | REC | ||
13 | DIA | Baseball | WMBA | Midget | HL | ||
14 | DIA | Baseball | WMBA | Midget | REP | ||
15 | DIA | Baseball | Misc. | Midget | REC | ||
16 | DIA | Baseball | WMBA | T-Ball (Minor) | HL | ||
17 | DIA | Baseball | WMBA | T-Ball (Major) | HL | ||
18 | DIA | Baseball | Misc. | T-Ball | REC | ||
19 | DIA | Baseball | WMBA | Peewee | HL | ||
20 | DIA | Baseball | WMBA | Peewee | REP | ||
21 | DIA | Baseball | Misc. | Peewee | REC | ||
22 | DIA | Baseball | Misc. | Recreational | REC | ||
23 | DIA | Baseball | WLU (Intramural) | MLSB | REC | ||
24 | DIA | Baseball | KW Rec Baseball | Recreational | REC | ||
25 | DIA | Baseball | WMBA | Rookieball | HL | ||
26 | DIA | Baseball | WMBA | Rookieball | REP | ||
27 | DIA | Baseball | Misc. | Rookieball | REC | ||
28 | DIA | Baseball | WMBA | Tyke | HL | ||
29 | DIA | Baseball | WMBA | Tyke | REP | ||
30 | DIA | Baseball | Misc. | Tyke | REC | ||
31 | CRT | Beach Volleyball | CARL | Coed | REC | ||
32 | CRT | Beach Volleyball | Misc. | Coed | REC | ||
33 | FLD | Cricket | Kaituer Cricket | Cricket | REP | ||
34 | FLD | Cricket | Waterloo-Sunrise Cricket | Cricket | REP | ||
35 | FLD | Cricket | AR Cricket | Cricket | REP | ||
36 | DIA | Fastball | KWMBFA | Bantam | REP | ||
37 | DIA | Fastball | KWMBFA | Bantam | HL | ||
38 | DIA | Fastball | Misc. | Bantam | REC | ||
39 | DIA | Fastball | KWMBFA | Mite | REP | ||
40 | DIA | Fastball | KWMBFA | Mite | HL | ||
41 | DIA | Fastball | Misc. | Mite | REC | ||
42 | DIA | Fastball | KWMBFA | Novice | REP | ||
43 | DIA | Fastball | KWMBFA | Novice | HL | ||
44 | DIA | Fastball | Misc. | Novice | REC | ||
45 | DIA | Fastball | KWMBFA | Squirt | REP | ||
46 | DIA | Fastball | KWMBFA | Squirt | HL | ||
47 | DIA | Fastball | Misc. | Squirt | REC | ||
48 | DIA | Fastball | Misc. | Mens | REC | ||
49 | FLD | Field Hockey | WRDSB | School | SCH | ||
50 | FLD | Field Hockey | WCDSB | School | SCH | ||
51 | FLD | Field Hockey | Misc. | School | REC | ||
52 | FLD | Football | TCMTF | Youth | REP | ||
53 | FLD | Football | WRDSB | School | SCH | ||
54 | FLD | Football | WCDSB | School | SCH | ||
55 | FLD | Football | Misc. | Adult | REC | ||
56 | FLD | Football | WLU (Varsity) | Adult | SCH | ||
57 | FLD | Lacrosse (Men's) | WLU (Varsity) | Mens | SCH | ||
58 | FLD | Lacrosse (Men's) | Misc. | Mens | SCH | ||
59 | FLD | Lacrosse (Men's) | KWMLA | Mens | REP | ||
60 | FLD | Rugby | WRDSB | School | SCH | ||
61 | FLD | Rugby | WCDSB | School | SCH | ||
62 | FLD | Rugby | Misc. | Adult | REC | ||
63 | DIA | Slo-Pitch (Co-Ed) | CARL | Coed | REC | ||
64 | DIA | Slo-Pitch (Co-Ed) | Misc. | Coed | REC | ||
65 | DIA | Slo-Pitch (Co-Ed) | Waterloo Rec Coed Slo-Pitch (Pacey) | Coed | REC | ||
66 | DIA | Slo-Pitch (Co-Ed) | Waterloo Chippers Slo-Pitch | Mens | REC | ||
67 | DIA | Slo-Pitch (Co-Ed) | All In The Family Slo-Pitch | Mens | REC | ||
68 | DIA | Slo-Pitch (Co-Ed) | Wloo Mens Slo-Pitch (Ali) | Mens | REC | ||
69 | DIA | Slo-Pitch (Men's) | CARL | Mens | REC | ||
70 | DIA | Slo-Pitch (Men's) | Misc. | Mens | REC | ||
71 | DIA | Slo-Pitch (Men's) | WRDSB | Mens | SCH | ||
72 | DIA | Slo-Pitch (Women's) | WRDSB | Womens | SCH | ||
73 | DIA | Slo-Pitch (Women's) | Misc. | Womens | REC | ||
74 | DIA | Softball | WMGSA | Bantam | HL | ||
75 | DIA | Softball | WMGSA | Bantam | REP | ||
76 | DIA | Softball | Misc. | Bantam | REC | ||
77 | DIA | Softball | WMGSA | Midget | HL | ||
78 | DIA | Softball | WMGSA | Midget | REP | ||
79 | DIA | Softball | Misc. | Midget | REC | ||
80 | DIA | Softball | WMGSA | Mini-Mite | HL | ||
81 | DIA | Softball | WMGSA | Mini-Mite | REP | ||
82 | DIA | Softball | Misc. | Mini-Mite | REC | ||
83 | DIA | Softball | WMGSA | Mite | HL | ||
84 | DIA | Softball | WMGSA | Mite | REP | ||
85 | DIA | Softball | Misc. | Mite | REC | ||
86 | DIA | Softball | WMGSA | Novice | HL | ||
87 | DIA | Softball | WMGSA | Novice | REP | ||
88 | DIA | Softball | Misc. | Novice | REC | ||
89 | DIA | Softball | WMGSA | Squirt | HL | ||
90 | DIA | Softball | WMGSA | Squirt | REP | ||
91 | DIA | Softball | Misc. | Squirt | REC | ||
92 | DIA | Softball | WMGSA | T-Ball | HL | ||
93 | DIA | Softball | WMGSA | T-Ball | REP | ||
94 | DIA | Softball | Misc. | T-Ball | REC | ||
95 | DIA | Softball | WLU (Varsity) | Womens | SCH | ||
96 | DIA | Softball | Misc. | Womens | REC | ||
97 | FLD | Soccer (Squirt) | WMS | Squirt | HL | ||
98 | FLD | Soccer (Squirt) | Misc. | Squirt | REC | ||
99 | FLD | Soccer (Squirt) | Royal City Soccer | Squirt | SCH | ||
100 | FLD | Soccer (Standard) | WMS | WMS - U11 B/G | HL | ||
Reference_Grp |
I would like to apply a filter to column A based on user selection, either DIA, FLD, or CRT.
This will result in onlt the DIA records exposed.
Excel 2003 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2 | Type2 | Activity | Organization | League | Calibre | ||
3 | DIA | 3-Pitch | WCDSB | St. Davids Boys | SCH | ||
4 | DIA | 3-Pitch | Region of Waterloo | Healthy Lifestyles | REC | ||
5 | DIA | 3-Pitch | WCDSB | St. Davids Girls | SCH | ||
10 | DIA | Baseball | WMBA | Bantam | HL | ||
11 | DIA | Baseball | WMBA | Bantam | REP | ||
12 | DIA | Baseball | Misc. | Bantam | REC | ||
13 | DIA | Baseball | WMBA | Midget | HL | ||
14 | DIA | Baseball | WMBA | Midget | REP | ||
15 | DIA | Baseball | Misc. | Midget | REC | ||
16 | DIA | Baseball | WMBA | T-Ball (Minor) | HL | ||
17 | DIA | Baseball | WMBA | T-Ball (Major) | HL | ||
18 | DIA | Baseball | Misc. | T-Ball | REC | ||
19 | DIA | Baseball | WMBA | Peewee | HL | ||
20 | DIA | Baseball | WMBA | Peewee | REP | ||
21 | DIA | Baseball | Misc. | Peewee | REC | ||
22 | DIA | Baseball | Misc. | Recreational | REC | ||
23 | DIA | Baseball | WLU (Intramural) | MLSB | REC | ||
24 | DIA | Baseball | KW Rec Baseball | Recreational | REC | ||
25 | DIA | Baseball | WMBA | Rookieball | HL | ||
26 | DIA | Baseball | WMBA | Rookieball | REP | ||
27 | DIA | Baseball | Misc. | Rookieball | REC | ||
28 | DIA | Baseball | WMBA | Tyke | HL | ||
29 | DIA | Baseball | WMBA | Tyke | REP | ||
30 | DIA | Baseball | Misc. | Tyke | REC | ||
36 | DIA | Fastball | KWMBFA | Bantam | REP | ||
37 | DIA | Fastball | KWMBFA | Bantam | HL | ||
38 | DIA | Fastball | Misc. | Bantam | REC | ||
39 | DIA | Fastball | KWMBFA | Mite | REP | ||
40 | DIA | Fastball | KWMBFA | Mite | HL | ||
41 | DIA | Fastball | Misc. | Mite | REC | ||
42 | DIA | Fastball | KWMBFA | Novice | REP | ||
43 | DIA | Fastball | KWMBFA | Novice | HL | ||
44 | DIA | Fastball | Misc. | Novice | REC | ||
45 | DIA | Fastball | KWMBFA | Squirt | REP | ||
46 | DIA | Fastball | KWMBFA | Squirt | HL | ||
47 | DIA | Fastball | Misc. | Squirt | REC | ||
48 | DIA | Fastball | Misc. | Mens | REC | ||
63 | DIA | Slo-Pitch (Co-Ed) | CARL | Coed | REC | ||
64 | DIA | Slo-Pitch (Co-Ed) | Misc. | Coed | REC | ||
65 | DIA | Slo-Pitch (Co-Ed) | Waterloo Rec Coed Slo-Pitch (Pacey) | Coed | REC | ||
66 | DIA | Slo-Pitch (Co-Ed) | Waterloo Chippers Slo-Pitch | Mens | REC | ||
67 | DIA | Slo-Pitch (Co-Ed) | All In The Family Slo-Pitch | Mens | REC | ||
68 | DIA | Slo-Pitch (Co-Ed) | Wloo Mens Slo-Pitch (Ali) | Mens | REC | ||
69 | DIA | Slo-Pitch (Men's) | CARL | Mens | REC | ||
70 | DIA | Slo-Pitch (Men's) | Misc. | Mens | REC | ||
71 | DIA | Slo-Pitch (Men's) | WRDSB | Mens | SCH | ||
72 | DIA | Slo-Pitch (Women's) | WRDSB | Womens | SCH | ||
73 | DIA | Slo-Pitch (Women's) | Misc. | Womens | REC | ||
74 | DIA | Softball | WMGSA | Bantam | HL | ||
75 | DIA | Softball | WMGSA | Bantam | REP | ||
76 | DIA | Softball | Misc. | Bantam | REC | ||
77 | DIA | Softball | WMGSA | Midget | HL | ||
78 | DIA | Softball | WMGSA | Midget | REP | ||
79 | DIA | Softball | Misc. | Midget | REC | ||
80 | DIA | Softball | WMGSA | Mini-Mite | HL | ||
81 | DIA | Softball | WMGSA | Mini-Mite | REP | ||
82 | DIA | Softball | Misc. | Mini-Mite | REC | ||
83 | DIA | Softball | WMGSA | Mite | HL | ||
84 | DIA | Softball | WMGSA | Mite | REP | ||
85 | DIA | Softball | Misc. | Mite | REC | ||
86 | DIA | Softball | WMGSA | Novice | HL | ||
87 | DIA | Softball | WMGSA | Novice | REP | ||
88 | DIA | Softball | Misc. | Novice | REC | ||
89 | DIA | Softball | WMGSA | Squirt | HL | ||
90 | DIA | Softball | WMGSA | Squirt | REP | ||
91 | DIA | Softball | Misc. | Squirt | REC | ||
92 | DIA | Softball | WMGSA | T-Ball | HL | ||
93 | DIA | Softball | WMGSA | T-Ball | REP | ||
94 | DIA | Softball | Misc. | T-Ball | REC | ||
95 | DIA | Softball | WLU (Varsity) | Womens | SCH | ||
96 | DIA | Softball | Misc. | Womens | REC | ||
138 | DIA | 3-Pitch | Misc. | Coed | REC | ||
139 | DIA | Fastball | Jr. Hallman Twins | Mens | PRO | ||
140 | DIA | Fastball | KWMBFA | Midget | REP | ||
141 | DIA | Fastball | KWMBFA | Midget | HL | ||
142 | DIA | Fastball | Misc. | Midget | REC | ||
143 | DIA | Fastball | KWMBFA | Peewee | REP | ||
144 | DIA | Fastball | KWMBFA | Peewee | HL | ||
145 | DIA | Fastball | Misc. | Peewee | REC | ||
Reference_Grp |
What I would like to do, is create a list of unique values in column B based on the filtered data. This list will be used in a userform combobox for the user to select from.
Then, using a similar method, this selected value will be then chosen to filter column B. Based on the resulting filtered database, similar code will be used to isolate the unique values in column C, for yet again another combobox.
These pocedures are basically a form of validation, allowing users to only select available selections for relevant choices.
Is this logic appropriate? How would I go about doing this? I am a novice coder, and would welcome any support to accomplish this feat.
Jenn