Adding Pasted Links

C

Champskipper

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
 
D

David Biddulph

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.
 
Top