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