Combo Box help

[tedc]

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

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

 

[BrianB]

Why not just add a column with the formula =RAND() copied down ?
(or copy the names to another sheet first).
Watch out. These numbers will change each time the sheet calculates, so at some stage select them and do Copy then Edit/Paste special/Values.

 

[tedc]

Thanks Brian
It doesn't matter if the RAND() changes. It was just to randomize the names. It has been sorted out now and works well
Thanks for your reply
Ted