| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link cells and when you update one it updates the other
Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to link cells and when you update one it updates the other
No because you will create a circular reference.
"b46ygurl" wrote: Is it possible to link two cells (that has the same information) and when you update one it automatically updates the other? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to link cells and when you update one it updates the other
Yes the second cell contains = and the reference of the first cell.
as in A1 is the one you will update and you want C1 to equal A1 you would put =A1 into C1. b46ygurl wrote: Is it possible to link two cells (that has the same information) and when you update one it automatically updates the other? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Updates | Excel Discussion (Misc queries) | |||
| Update link cells without open up source document files | Excel Worksheet Functions | |||
| Link two cells to automatically update | Excel Discussion (Misc queries) | |||
| How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions | |||
| Link Updates | Links and Linking in Excel | |||
Hybrid Mode
