Dependent drop down from a different sheet in same workbook

[jdv07c]

Organizing product. I'm trying to create a hierarchy chart I guess you could say. If the product is one category then the next choices will depend on the first choice. I understand how to create a drop down list so for my first group I'm good. But for my next column I want it to be specific to the prior choice. Also I'm using Data from seperate sheets so my final sheet where things are organized is clean. Could I get some assistance I've been searching for days. Thanks!

 

[danzon]

try

http://www.contextures.com/xlDataVal02.html

 

[Smitty]

Welcome to the Board!

Check out Zack Barresse's article here.

You'll also find some good links at the bottom.

HTH,

 

[jdv07c]

Thanks. I do understand all that. My question has to do with pulling this from a seperate sheet.

 

[danzon]

doesn't matter which sheet it is on.... if you name the ranges excel won't care which sheet they are on. Just be sure to used named ranges

see the contextures link.... do as it says but feel free to go ahead and perform each step in seperate worksheets... it will still work fine

 

[jdv07c]

Ok. I'm getting dependent lists but my issue is that for every row in my second column, they are all depending on the 1st row 1st column. Even if I change my 2nd Row 1st column the 2nd row/2nd column still is based on the 1st row/1st column. -.-

 

[Biz]

Post a sample workbook if you can.