Combo Box help

tedc

Board Regular
Joined
Oct 31, 2003
Messages
194
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
ABCD
1EntryOwner
2AceWJones
3AjayTCullen
4AlexLFarrell
5AprilTMurphy
6BensonTMaddan
7BoscoKBrady
8BuddyJRenshaw
9BunjeelHarvey
10CartmanGButler
11ChaseHSmith
12ChikoLSteele
13ChippyBGibson
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
ABCD
1RandEntryOwner
20.473215Chase
30.630105Max
40.561841Twister
50.151168Bosco
60.09059Cartman
70.830658Rose
80.963131May
90.768831April
100.742581Mouse
110.101587Sybil
120.898132Benson
130.841927Cody
140.890732Ajay
150.899262Jasmine
160.654246Milky
170.428127Chips
Entries


Thanks
Ted
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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

Board Regular
Joined
Oct 31, 2003
Messages
194
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
 

Watch MrExcel Video

Forum statistics

Threads
1,126,980
Messages
5,621,946
Members
415,869
Latest member
LWSkinner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top