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.

Hi Pavan,

We're unable to understand your request fully, please elaborate your request a little more. A sample work of yours would be of great help.