Need help on Drop down list from data validation depends upon first value select

Dear expert

I have set of 5 column values multiple repeats values in every column..
1.REGION
2.PARTS
3.TYPE
4.CALL CODE
5.OS INSTALL

i want create drop down list for each 5 column , get values list depends upon values select in first dropdown list, like e.g

IF EAST SELECT IN REGION DROPO DOWN LIST = LEBOUR ONLY,LABOUR PART WILL DISPLAY HERE IN DROP DOWN LIST


IF LABOUR ONLY SELECT IN THE PARTS DROP DOWN LIST = AAA,DDD WILL DISPLAY HERE IN DROP DOWN LIST
IF LABOUT PART SELECT IN THE PARTS DROP DOWN LIST = BB,FF WILL DISPLAY HERE IN DROP DOWN LIST

IF AAA SELECT IN THE TYPE DROP DOWN LIST = A100,A101 WILL DISPLAY HERE IN DROP DOWN LIST
IF FF SELECT IN THE TYPE DROP DOWN LIST = A120 WILL DISPLAY HERE IN DROP DOWN LIST

IF A100 SELECT IN THE CALL CODE DROP DOWN LIST = WIN 8 WILL DISPLAY IN THE OS INSTALL DROP DOWN LIST
IF A101 SELECT IN THE CALL CODE DROP DOWN LIST = WIN 8 WILL DISPLAY IN THE OS INSTALL DROP DOWN LIST
IF A120 SELECT IN THE CALL CODE DROP DOWN LIST = WIN 7 WILL DISPLAY IN THE OS INSTALL DROP DOWN LIST



i want apply this condition in sheet "master"

please find the attachment....

I will be able to provide you the VBA code, would it be okay for you.


_______________________________________________________________________________________________________________________
Please click * to say thanks

Experts can u help on this???

Yes Sir I understand the value of efforts and age of experience i have nt seen ur profile..reason that i have called u dude Pls dont mind sir

I would like to solve with ur experience and salute to ur experience ,,, I am good in excel formula even in data-validation but vice versa datavalidation is something typical for me i have understand logic but implement way i lost it... pls sir help me on this thread... i looking for ur reply thanks for spending your valuable time for my thread