I'm keeping grades in multiple worksheets in the same workbook. I'd like to
copy the column showing the total of the weekly grades (using the SUM
formula) on worksheet 2 to the column on worksheet 1 for that assignment
(worksheet 1 reflects all the assignments which is why I just need the sum).

When I simply do a copy and paste, I get #REF in the 'weekly' column and in
the 'total' and 'grade' columns (total is the total of all assignments, grade
is a series of if, then statements so I end up with A, B, C etc).

How do I do this to just get the number and not mess up worksheet 1?

Thanks.