| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro adding formula to new sheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a formula to a macro | Excel Discussion (Misc queries) | |||
| Sum total formula for adding 2 columnson time sheet | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
