Creating dependent lists for use in different worksheets

[alis88]

Hello

I was wondering if someone could help me.

I have two separate worksheets (Production and Stock) with the same few columns (Which Laboratory? and Where in Laboratory?).

In the Which Laboratory? column, I need basically a list for the user to select a lab from (Lab1, Lab2, Lab3 etc).

Depending on which option was selected from the Which Laboratory? column, the Where in Laboratory? column will display different choices.

For example, if Lab1 was selected from the first list then the second list will display a, b, c; but if Lab2 was selected then the second list will display d, e, f.

I have done this using data validation but it will only work on the sheet where I contain the lists, and I don't want this. I want the lists to be held on a different worksheet. Excel doesn't allow you to reference other worksheets in the validation procedure.

Perhaps I can use a lookup function, but I'm not sure where to start to be honest.

Can someone help please?

Thank you in advance.

Alis

[davesexcel]

Hi,
It will work if you name the list range, check this out
http://www.contextures.com/xlDataVal01.html

check this out on dependent drop down lists:
http://www.contextures.com/xlDataVal13.html