I have a cell containing a drop down box with three options. Can i design my
worksheet so that when one option is selected a drop down box in the
neighbouring cell appears with a number of options in it?

Each of the original 3 options in the first drop down box needs to lead to a
different list in the second drop down box, though the options can be
repeated.

Any help would be much appreciated.

Thanks