To Make a Changing Data Sheet

S

ShellyK

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?
 
A

Ashish Mathur

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
 
S

ShellyK

Hello Ashish,


This is what I am currently working on:


My Imput Headers are:

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 Are:

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Creating a template that is manually updated from another sheet. 6
Dependent drop down dynamic range formula, off sheet. 7
Copy corresponding cell in Column B if cell in A contains certain text? 1
Summing multiple validated sheets into a summary sheet 3
display filter selection from menu 2
COUNT rows on external sheet if between date range 3
if or lookup for facturations 2

Top