Generate dependant dropdowns on columns

**axecel** · 07-28-2010, 08:05 AM

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

**Domski** · 07-28-2010, 08:14 AM

This might help: http://www.contextures.com/xlDataVal02.html

Dom

**axecel** · 07-28-2010, 08:33 AM

hi,
i went through the link but it is not exactly serving my purpose.
I have my data in the above said fashion i.e from a1-d2 and do not have three columns as given in the example.

**Domski** · 07-28-2010, 08:36 AM

It'll be easier to change the layout of your data than come up with a different solution.

Excel likes data going down columns more than it does across rows.

Dom

**axecel** · 07-28-2010, 08:48 AM

True.
Thanks for your help.

**axecel** · 07-29-2010, 03:07 AM

I need to re-open this issue.Say there is a third column associated with it as well.Let us take this as price

chocolate chocolateA 10
chocloate chololateB 20
biscuit biscuitA 30
biscuit biscuitB 40

Now in this case, i cannot re structure the data as you suggested because if i were to make it into a row wise approach i would miss out on the Price column.

So keeping the same structure as i quoted above, is it possible to create two dependant dropdowns ?