| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
link cells?
Is there a way to link cells on two different worksheets so that when
you edit one, the other automatically copies? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
link cells?
Hi jdifrancesco1-
Enter a formula in one cell that refers to the other. Select the cell on worksheet A and press =. Then navigate to worksheet B, select the second cell, and press Enter. That process puts a formula in the cell on worksheet A that will reflect any change to the cell on worksheet B. -- Jay " wrote: Is there a way to link cells on two different worksheets so that when you edit one, the other automatically copies? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link All cells of Sheet1 to All Cells of Sheet2 | Links and Linking in Excel | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
| PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
| How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions | |||
Hybrid Mode
