Hi, I am trying to create a costing package for the my company and I am completely new to to the intracacies of excel.

I would like there to be check/option boxes which I can click and when clicked will activate certain rows whcih already contain formulas that calculate the total costs for the components I need costing.

An example would be, I need a checkbox that states "Covertrims + Decorated" and another that states "Tape, Jointed + Skim" and when one is selected, it will activate certain rows, and hide certain other rows. Vice-versa also applies. Some rows are needed for both checkboxes as well, and only one checkbox can be selected at a time.

I hope someone can help as I would be eternally grateful.

Nic