ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding Pasted Links (https://www.excelbanter.com/excel-discussion-misc-queries/250790-adding-pasted-links.html)

Champskipper

Adding Pasted Links
 
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

David Biddulph[_2_]

Adding Pasted Links
 
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





All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com