Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Make a Changing Data Sheet
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Make a Changing Data Sheet
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Make a Changing Data Sheet
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Make a Changing Data Sheet
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing data orientation from one sheet to another | New Users to Excel | |||
How do I make the data sheet appear in my power point presentation | Excel Worksheet Functions | |||
changing name of data sheet in a application | New Users to Excel | |||
Changing data orientation from one sheet to another | New Users to Excel | |||
How can I make an automatic calculation in changing sheet? | Excel Discussion (Misc queries) |