Hello,
I have a workbook with 2 sheets.
Sheet 1 contains 3 rate plans all with their own checkbox (form)
1. Basic
2. Advantage
3. Gold
I have a second sheet that all the inclusions of the rate plans.
I have added on the top of the sheet the rate plans and a check box next to the inclusion under each rate plan.
I would like to have inclusions ticked on sheet 2 based on the rate plan selected in sheet 1.
For example -
If the Basic rate plan was selected then all the options identified for Basic would be ticked with all the other check boxes protect.
If however a customer wanted Gold, all the inclusions must be ticked from Basic and Advantage.
Thanks
Mike
I have a workbook with 2 sheets.
Sheet 1 contains 3 rate plans all with their own checkbox (form)
1. Basic
2. Advantage
3. Gold
I have a second sheet that all the inclusions of the rate plans.
I have added on the top of the sheet the rate plans and a check box next to the inclusion under each rate plan.
I would like to have inclusions ticked on sheet 2 based on the rate plan selected in sheet 1.
For example -
If the Basic rate plan was selected then all the options identified for Basic would be ticked with all the other check boxes protect.
If however a customer wanted Gold, all the inclusions must be ticked from Basic and Advantage.
Thanks
Mike