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
|