| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pasting Links
How do paste links from one worksheet to another worksheet in the same
workbook with out it changing info or adding "0" in blank cells. |
|
#2
|
|||
|
|||
|
When you Paste Link, it creates a reference to the original cell.
For example: =A1 You can modify the formula: =IF(A1="","",A1) shertay wrote: How do paste links from one worksheet to another worksheet in the same workbook with out it changing info or adding "0" in blank cells. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
| HELP!!! Missing Links!!! | New Users to Excel | |||
| Pasting links | Excel Worksheet Functions | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
