i have small doubt regarding the use of microsoft.
suppose cell A2 has a dropdown list containing football, basketball , cricket. wen i select football i need a dropdown list to appear in cell B2 with the option spain, italy, england etc. and wen i select any of these options in cell B2 i need to get an another dropdown list in cell C2 with the names of the players.
similarily if i select cricket in cell A2 then i get a dropdown list in cell B2 with India, pakistan, australia etc. wen i select an option in cell B2 i need to generate a drop down box in cell C2 with th names of the players