Data Validation

[Nuno Silva]

Hy all

I have a question very important and for me very hard

I have 2 Data Validations in Sheet2.

Data Validation A (Machines, about 72)
Data Validation B (Molds, about 596)

Machine 1 does X,Y,Z molds
Machine 2 does P,Q,R molds
Machine 3 does Q,W,E,R,T,Y molds
...


Is there any function or code to just show the molds by the selected machine ? Or i have to change to combo boxes ?
After that saves to Sheet3, but that is done.

I would like something like in each Validation Data:
Machine : ACP1
Molds : S034
SSI022
CDI102


Any more information ask please.
Thank you

 

[Danerida]

Google is your friend.

http://www.contextures.com/xlDataVal02.html
&
Dependent Validation. Excel Data Validation List Based on the Value of Another

Dan

 

[Nuno Silva]

Awesome excel brother

Thanks a lot