|
| 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
April 19th, 2010, 07:44 PM
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
April 19th, 2010, 08:15 PM
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  5 on Sheet2: Type =SUM(; open Sheet2, and select the range D1 5, 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 5 - observe the single quotesDoes 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 | |
|
|
Linear Mode
