Hi Shelly,

What inputs would you like to take from the sheet named cooling tower.
Please give some more details.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ShellyK" wrote in message
...
Hi,

I need to make a Data Sheet. The First Sheet will have the imputs and the
following sheets will have calculations.

On the imputs sheet, I want to be able to select, on one cell, from a pull
down menu several different items, but then I want to be able to put in
different info for each item and then based on what item I choose on the
Pull
down menu I want it to go to the specific calculation sheet and do the
calculation that certain way.

Example:

If I choose Cooling Towers from the drop down menu and I imput in it's
Horsepower in the cell next to it, I want it to be able to go to the sheet
Labeled Cooling Towers and take what I imputed for the Horsepower do the
Calculations and then on Sheet 1 imput the answers for the calculations in
the designated cells.

I have an idea how I would be able to do this in C++ but my office wants
me
to do it Excel. Is there any way?