| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data table with inputs from a differente worksheet
How can i create a data table in excel 2007, with inputs, formulas and
calculation from a diferent worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data table with inputs from a differente worksheet
If the cell A1 of Sheet2 has the value 10, then the formula =Sheet2!A1 will
return the value 10 Let's say I want to make the a formula on Sheet1 to sum a range D1:D5 on Sheet2: Type =SUM(; open Sheet2, and select the range D1:D5, type ); click the green check mark in Formula Bar or press Enter key to commit formula Not that if the sheet's name has spaces in it I will get a formulas like =SUM('Jan Sales'!D1:D5 - observe the single quotes Does this answer your question? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "gu" wrote in message ... How can i create a data table in excel 2007, with inputs, formulas and calculation from a diferent worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| table lookup with two inputs one output | Excel Worksheet Functions | |||
| Is there a function like "Data Table" for multiple Inputs | Excel Worksheet Functions | |||
| how do i get my data table column inputs to work? | Excel Discussion (Misc queries) | |||
| Can Row and Column Inputs in 2 Var. Data Table be on a separate sh | Excel Discussion (Misc queries) | |||
| Can Row and Column Inputs in 2 Var. Data Table be on a separate sh | Excel Discussion (Misc queries) | |||
Linear Mode
