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