I am trying to create combo boxes that will lookup information from ‘Dog Info’sheet ie ‘Entry’ and ‘Owner’ which would be a progressive list and can grow quite long
And transfer this information to ‘Entries’ sheet and give each entry a random number for sorting into race heats.
The ComboBox would appear on this sheet (Entries)
Thanks
Ted
JR Race Daze.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Entry | Owner | ||||
2 | Ace | WJones | ||||
3 | Ajay | TCullen | ||||
4 | Alex | LFarrell | ||||
5 | April | TMurphy | ||||
6 | Benson | TMaddan | ||||
7 | Bosco | KBrady | ||||
8 | Buddy | JRenshaw | ||||
9 | Bunjee | lHarvey | ||||
10 | Cartman | GButler | ||||
11 | Chase | HSmith | ||||
12 | Chiko | LSteele | ||||
13 | Chippy | BGibson | ||||
Dog Info |
And transfer this information to ‘Entries’ sheet and give each entry a random number for sorting into race heats.
The ComboBox would appear on this sheet (Entries)
JR Race Daze.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Rand | Entry | Owner | |||
2 | 0.473215 | Chase | ||||
3 | 0.630105 | Max | ||||
4 | 0.561841 | Twister | ||||
5 | 0.151168 | Bosco | ||||
6 | 0.09059 | Cartman | ||||
7 | 0.830658 | Rose | ||||
8 | 0.963131 | May | ||||
9 | 0.768831 | April | ||||
10 | 0.742581 | Mouse | ||||
11 | 0.101587 | Sybil | ||||
12 | 0.898132 | Benson | ||||
13 | 0.841927 | Cody | ||||
14 | 0.890732 | Ajay | ||||
15 | 0.899262 | Jasmine | ||||
16 | 0.654246 | Milky | ||||
17 | 0.428127 | Chips | ||||
Entries |
Thanks
Ted