I have an excel sheet which contains details of several ships such as fuel consumption, speed, tons, no. of cranes etc. based on which I have to perform certain calculations. The above details are entered into the sheet manually inorder to calculate the maximum amount of cargo that I can load on that ship. So, at the top of the sheet I made a drop down list of the names of all the ships. I am trying to make all the data underneath to change to their respective ships' particulars based on the selection at the top.

I would appreciate if someone could help me with this.

Thanks

Ihsan

Ihsan,

This is a fairly standard modelling exercise. Thae basics of which are to have an input sheet (could be multiple input sheets but we don't want to confuse the example) which is a block table of information on every ship. It should look something along the lines of:

ID Ship Name Speed Tons ...
01 Bravo 10 1000 ...
02 Delta 20 1500 ...
03 Tango 50 50000 ...
...

depending on what data you've got. Then on a separate calculation sheet you want to pull information for a specific ship off the table. The best way to do this is to have a couter input cell at the top of the calculation sheet which can be set to a number. Then below the counter input cell you pull the set of information for any one ship through by using a series of INDEX formulae. i.e. to get the Ship Name you'd type the following formula (assuming the input table was the above demonstrated table and was found on cells A1:D4 of sheet Inputs and that the counter cell was in cell A1 of the current sheet) : With this method you can dynamically pull through the inputs for any one ship by amending the counter cell and these one-ship specific set of inputs can then be linked up to a set of ship specific calcs to give whatever answer you need for particular ships.

Hope this helps,
Maccas

Thanks a bunch! That really helped.