I have searched the help-base, and to no avail...the easiest of tasks perhaps
and I cannot get it right.

I have a column that ends in a sum (such as B2 though B 29 equals B30 on
WORKSHEET 1). I want that value to show in a box in Worksheet 2. Since B30
is a formula in itself, each time I tinker with it, I get REF errors of
sorts, and no idea how to get it right.

Any suggestions???