If you've got a formula like =Sheet1!B1+Sheet1!C1, you can copy the formula
as far down the column as you like, and the references will change the
appropriare row as you copy down.
--
David Biddulph

"Champskipper" wrote in message
...
I need to add two values together and paste the results in a different
worksheet. I have a table with many of these operations. Short of typing
the
full links, is there a short cut way to do this?

thanks
--
Champskipper