Anyone,

I have a list of 25 swimming events and a list of 60 swimmers who will each
swim in four different events. To make life easier I have created a combo
box (which to me is already a feat).

The data is in column A, rows 2-20. Ive placed box itself in the B column.
It is one row high but when I click on the box, it shows me all the events
(which is preferable to a drop-down box).

The input box is A2:A20.
The cell link is D2:d20.

When I click on the combo box it will put the entry into D2. However, if I
go to D3 and click on the combo box and change my choice, it changes in D2
but remains blank in D3.

If I copy the combo box and place it the next line down and choose an
option, then the first line changes to what Ive selected for D3 -- unless I
manually change the cell link to start at D3. Then it works fine.

The catch is that I would have to repeat this process 240 times (60 racers
times four events). Is there a way to automate this or alternatively, is
there a better way to get what I want done?

Thank you.