To Make a Changing Data Sheet

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?

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?

Hello Ashish,


This is what I am currently working on:


My Imput Headers a

Equipment Description - Pull down menu for list to choose from
Unit
System
Equipment Capasity
Equipment Description
Type
Area
Size
Driver type
Voltage
Driver HP
Driver RPM
Vender Info
Equipment Model No

My Output Headers A

Awt Lw-

and

Octave Band Center Frequencies

Hz 31 63 125 250 500 1000 2000
dB output output output output output output
outpu


For each Equipment Service Description there will be different way to
calculate my Lw and Octave bands. These calculations are on different sheets
behind the Sheet 1-input/output page. I want to be able to select my
Equipment Description and imput the imputs and then the output will appear
next to it on Sheet 1 depending on how it is suppose to be calculated
according to what I select for Equipment Description.

Thank you very much for your help. I'm sorry I couldn't be clearer, I see
how I need it but it's hard to describe.




"Ashish Mathur" wrote:

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?

Hi,

Can you mail me the file and explain the problem very
clearly.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ShellyK" wrote in message
...
Hello Ashish,


This is what I am currently working on:


My Imput Headers a

Equipment Description - Pull down menu for list to choose from
Unit
System
Equipment Capasity
Equipment Description
Type
Area
Size
Driver type
Voltage
Driver HP
Driver RPM
Vender Info
Equipment Model No

My Output Headers A

Awt Lw-

and

Octave Band Center Frequencies

Hz 31 63 125 250 500 1000 2000
dB output output output output output output
outpu


For each Equipment Service Description there will be different way to
calculate my Lw and Octave bands. These calculations are on different
sheets
behind the Sheet 1-input/output page. I want to be able to select my
Equipment Description and imput the imputs and then the output will appear
next to it on Sheet 1 depending on how it is suppose to be calculated
according to what I select for Equipment Description.

Thank you very much for your help. I'm sorry I couldn't be clearer, I see
how I need it but it's hard to describe.




"Ashish Mathur" wrote:

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?

Sorry

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ashish Mathur" wrote in message
...
Hi,

Can you mail me the file and explain the problem
very clearly.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ShellyK" wrote in message
...
Hello Ashish,


This is what I am currently working on:


My Imput Headers a

Equipment Description - Pull down menu for list to choose from
Unit
System
Equipment Capasity
Equipment Description
Type
Area
Size
Driver type
Voltage
Driver HP
Driver RPM
Vender Info
Equipment Model No

My Output Headers A

Awt Lw-

and

Octave Band Center Frequencies

Hz 31 63 125 250 500 1000 2000
dB output output output output output output
outpu


For each Equipment Service Description there will be different way to
calculate my Lw and Octave bands. These calculations are on different
sheets
behind the Sheet 1-input/output page. I want to be able to select my
Equipment Description and imput the imputs and then the output will
appear
next to it on Sheet 1 depending on how it is suppose to be calculated
according to what I select for Equipment Description.

Thank you very much for your help. I'm sorry I couldn't be clearer, I see
how I need it but it's hard to describe.




"Ashish Mathur" wrote:

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?