hi i have a forumla which adds up the result from 3 other formulas and
gives me a total. I have created a macro for this total to be added to
sheet 2. The macro works and adds the forumla to sheet to but gives the
value of o as it is adding the cells in sheet 2 not sheet 1. This is my
formula =SUM($H$33,$G$576,$D$582) i can not add sheet1! infront of each
cell as when ever the number in sheet 1 changes the number in sheet 2
changes as well and i do not want this to happen. please help me i need
this for my coursework and need it in for tomor. i have given a link for
images of the spreadsheet below please help asap. thanks.

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=521861