hi i have created a macro which moves one of my formulas to sheet 2 but
when i use the macro the formula is moved to sheet 2 but the value is 0
this is the formula i want moved to sheet 2 =SUM($H$33,$G$576,$D$582) i
would put "sheet1!" in front of each cell but then each time the value
in sheet 1 changes, the value in sheet 2 changes as well and i do not
want this to happen. here are some screen shots of my problem please
help me someone i need it done for tomorow pleaseeeeeee thanks.

screenshots
http://img379.imageshack.us/img379/5088/sheet13zc.jpg
http://img379.imageshack.us/img379/2613/sheet28vd.jpg


--
toddsavage100
------------------------------------------------------------------------
toddsavage100's Profile: http://www.excelforum.com/member.php...o&userid=32416
View this thread: http://www.excelforum.com/showthread...hreadid=521939