Need a Macro to Reset Dependent Data Validation.

Hi,

Example:

Cell C3 has Regions and Cell I3 has Countries. (Dependent Data Validation)

When Cell C3 is clicked, I3 should be populated as " GRAND TOTAL".

Thanks in advance.

Pavan.