Automatically change the Drop-Down List Values with a Macro

[all4excel]

In my WorkSheet, The Dropdown values change the entire structure in the Sheet and I have around 3 such dropdowns and 1 of them is interdependent on the other.

My reports are based on these Dropdown values and I need to make reports as copies of this Sheet as Values, however I have to change the Dropdown values everytime to make a report..

Can this be Automated with a Macro which Automatically changes the List values in the Drop-Down and thus changing the Sheet completely.

I tried recording a Macro but it does not show anything to do with a Drop-Down elements.

I am using a SImple Drop-Down..
i.e. Data -> Data Validation -> Allow -> Any Value -> List

Regards
all4excel

 

[all4excel]

Thanks for the Info DatSmart,

I will look into that!

Warm regards
all4excel

 

[AmitVrma]

High risk covers at low premium. Comprehensive risks cover for one year after 3 years premium payout. Optional higher cover throughout Term Riders. The policyholder can choose a maximum term but can surrender at any time without any surrender penalty or loss after 5 years. Any number of withdrawals through partial surrendering in this LIC Jeevan Saral plan; other more benefits log on to the website: www.lifeinsurancechandigarh.com

_______________________________________
LIC Jeevan Saral, life insurance, LIC, LIC Policy