Hi,
i have say two sheets in my workbook.SheetA and SheetB.

Sheetb has the following data in range A1-D2

chocolate chocolateA
chocloate chololateB
biscuit biscuitA
biscuit biscuitB

Now in Sheet A , i need two dropdowns.

In one column, i need to select from either chocolate or biscuit using a dropdown.

In the next column, depending on what was selected earlier, i need a new dropdown consisting of corrosponding values.

So if chocolate was selected, then the 2nd dropdown should contain values, chocolateA and chocolateB.

Is this possible to achieve? If so can somebody assist me.

Thanks,
Praveen