Hello Martin...

Yes, i am populating the drop down using ranges and data validation.
The Issue here being, the cell containing the second drop down list
"retains" the value of the previous selection.

For example :

Drop down list in Cell A1 lists all the Categories.

Drop down list in Cell B2 lists all the products.

For the first time, the selection in the Cell A1 (Categories) populates
the data in the drop down list of the Cell B2 ( Products)

From the Second time, if the selection in the Cell A1 Changes, the drop
down list populating the Cell B2 changes, but NOT the content of cell
B2,which retains the value of the previous selection . I need to clear
the value present in the cell B2 ( which is a value from the previous
selection)

Hope i am clear in conveying my requirements.

Please let me know if there any issues, else i can send the excel file
across..

Thanks once again for spending your time on this..
Sagar