If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 D15 on Sheet2: Type =SUM(; open Sheet2, and select the range D15, 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'!D15 - 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? |
Thread Tools | |
Display Modes | |
|
|