| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving values from sheet to another
I would like to know if it is possible to create a formula on one sheet (sheet 2) and copy that resulting value to another sheet (main sheet). So when I make changes to the formula on sheet 2 it will update on the main sheet and be used in another formula on that sheet (main sheet). Is this possible? Thank you. :) :) -- makdaddy925 ------------------------------------------------------------------------ makdaddy925's Profile: http://www.excelforum.com/member.php...o&userid=29385 View this thread: http://www.excelforum.com/showthread...hreadid=491898 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving values from sheet to another
On the main sheet in the cell to which you want to carry forward the value
from Sheet2 type =Sheet2!A1 where A1 is the cell on sheet 2 where the formula resides. Is this what you are wanting to do? "makdaddy925" wrote: I would like to know if it is possible to create a formula on one sheet (sheet 2) and copy that resulting value to another sheet (main sheet). So when I make changes to the formula on sheet 2 it will update on the main sheet and be used in another formula on that sheet (main sheet). Is this possible? Thank you. :) :) -- makdaddy925 ------------------------------------------------------------------------ makdaddy925's Profile: http://www.excelforum.com/member.php...o&userid=29385 View this thread: http://www.excelforum.com/showthread...hreadid=491898 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the maximum of a subset of values on a different sheet | Excel Discussion (Misc queries) | |||
| Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| Formulas not recalculating when values change on another sheet | Excel Worksheet Functions | |||
| Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
Linear Mode
