| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Workbooks - adding lines and keeping links | Excel Discussion (Misc queries) | |||
| help: paste special with an operation (add, multiply,...)converts everything to values, pasted formulas & links are lost | Excel Discussion (Misc queries) | |||
| Keep integrity of pasted links when data is later sorted | Excel Worksheet Functions | |||
| Adding rows without the links moving | Excel Worksheet Functions | |||
| Adding or removing additonal links | Excel Discussion (Misc queries) | |||
Hybrid Mode
