Excel 2000 proof checking calculated columns electronically?

[Bane]

Just checking if this sounds feasible in Excel 2000. Or suggest how to go about it; bearing in mind I have very basic knowledge of Excel.

The situation we have is called a system check that fills set values into columns, e.g. weights. We then print this out and check the calculated results match what is on the original master print out.

So my question is can this be done electronically instead, by comparing system check values against a write protected master version of the spreadsheet? All I could think of is having another tab with the master version on, and telling the system check tab to spot a difference between the two. Then maybe highlight the cell red to draw attention to difference.

 

[Participant]

Easily, but as far as error checking in Excel goes, I normally just highlight both columns and if the totals are both say 10,452.13 in the little 'sum' bit at the bottom right of the Excel window, then you could safely say that the filled values match the master.