OK, let's try again. I am in 1 workbook. I am trying to take 1 cell in 1
worksheest that has a function of summing a cloumn of about 10 cells. I want
that auto sum to show up in a different worksheet. I want the updated total
to reflect in both cells without having to go throught the update cycle of
closing the workbook, etc.

Please help.