| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking worksheet information
how can i link the information from one spreadsheet to another, so that the
data will change on both pages when info is updated? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking worksheet information
"krys" wrote in message
... how can i link the information from one spreadsheet to another, so that the data will change on both pages when info is updated? Select the relevant cell in the destination sheet, type = to start the formula, go to the source sheet, select the relevant cell (which will include that cell's reference in the formula in the destination sheet), and accept this. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas and worksheet linking | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Excel worksheet linking | Excel Worksheet Functions | |||
| Obtaining information from a database for a worksheet | Excel Discussion (Misc queries) | |||
| Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Linear Mode
