Example:
In excel column 'H' is a Country field and 'I' is State field. Both the fields are drop down fields. Now user can choose any one country from the drop down, based on that state drop down values will be populated. Now say if user chooses 'India' from the drop down in the cell 'H3', drop down in 'I3' will be populated with the states in India.
This can be done in excel using data validation and Indirect() function. But how to achieve the same in excel using c#? Any help would be appreciated.