I want to use a drop-down list to decide what information appears in cells elsewhere. I have attached the sheet in question with this enquiry.
If I choose 'Slab-mount' at C2, I want the information in B11:D13 to disappear entirely. If I choose 'Tank-mount' at C2, I want the information in B6:D9 to disappear entirely.
Furthermore, if I choose 'Slab-mount' at C2, then I also want the information in cells B4:C4 to disappear entirely.
Also, if I choose 'Semi-spherical' in C4, then I need the data at C12 and C13 to point to a particular work sheet (not shown in my included example), whereas if I choose 'Ellipsoidal' in C4 then I need the data at C12 and C13 to point to another worksheet. I know how to handle these worksheets with the input data from C12 and C13, once I know how to direct this data to the right place.
Finally, if I have selected 'Slab-mount' at C2, then the data at C7, C8 and C9 can be directed to yet another worksheet, which I know how to handle.
So the summary is: how do I use drop-down boxes, and the results thereof, to determine what information appears in other cells to enable a user to only see and select the information relevant to the case in hand? If he choses a 'Slab-mount', he doesn't need to see anything about a 'Tank-mount', and vice-versa. If he does chose the 'Tank-mount', he can then answer the further question about its geometry, which won't change the numbers he enters at C12 and C13, but will enable me to direct those numbers to a different worksheet (the calculations for a semi-spherical design being different from an ellipsoidal design). I can deal with all the 'downstream' issues, but do not know how to enable this 'upstream' selection of fundamental principles.