Variable drop down list
 

Hi,

Excel 2000

I have a drop down box on a worksheet that when clicked shows the items
listed in another part of the file, my question is, can the drop down list
be restricted in what it shows depending on a cell having an entry. For
example, if I put FULL in cell A1 the list shows all entries, whereas if I
put PART in cell A1, only a few items show in the drop down list.

Any help most welcome.

Rob