Hi
i have 5 column table - 1st column -"product" ,2nd column-"A",3rd column-"B",4th column-"C",5th column-"D"

Product are selecting from drop down list.The drop down data come another sheet.
have 4 product (Name) LSOU ,LCOU,COC,DEC


If select each product name to row "LSOU" , "LCOU" , "COC", "DEC" then
2nd column is need to automatic fill "not required"
3rd column is need to automatic fill "No"
4th column is need to automatic fill "not required"

can any one help me..
Thank you