Hi Everyone
I want to know how I can have only the selected list in Cell B1 based on selection in cell A1
Example
I have a drop down list in Cell A1 containing 3 items (Apple-Orange -Banana)
and on the cell B1 have another dropdown list but I want to have only Green -Yellow to be selected in cell B1 when I choose Banana in cell A1
and same for orange I need to have only Orange -Red-Blue in cell B1 when I select Orange in cell A1
Thanks
Bakar
Bookmarks