Drop down to select the method of calculating of freight of different types

[mohammedalkhatim]

Hello Everyone,
I would like to have a drop down menu listing the following two choices:
1. tonnage.
2. volumetric

I've attached a book that, consist of two sheet the 1st sheet containing the method of calculation the volumetric (the user has to fill the length and width and height) then will automatically generate the weight according to predefined equation (the same i made in the second sheet "Break bulk" ) in which will calculate weight/ton.

I 'm currently looking forward to maximize my effort to do the following:
merge the two sheets in single sheet and make a drop down list as per above requirement in order to do the following:
- if the user has selected tonnage from the drop down menu and filled the quantity of that , then it has to calculate the entered amount of weight"tonnage".
- if the user has selected volumetric from the drop down menu then it has to generate automatically three cells additional with the following:
1. First Cell for length
2. Second Cell for width
3. Third Cell for height
i have also made a formulas to obtain the above three values and execute the equation then take the result "in which would be the equivalent of tonnage and complete the rest of calculations.

Does anybody can support me on doing that and make a valuable input for attractive view, i 'm highly appreciate this effort.

Freight Calculator_shared.xlsx

Thanks very much.