| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically update a 2 lists
I have two identical lists in 2 separate speadsheets.
How can I automatically update both lists by only entering new data into one os the lists. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically update a 2 lists
Allan
Check out help on "linking" or "links". Note: you can only go one way using links. i.e. you cannot link sheet1 to sheet2 and sheet2 to sheet1 using same cells. Gord Dibben Excel MVP On Tue, 15 Nov 2005 05:14:31 -0800, "Allan" wrote: I have two identical lists in 2 separate speadsheets. How can I automatically update both lists by only entering new data into one os the lists. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
| How do i update hyperlink in excel spread sheet automatically. | Excel Discussion (Misc queries) | |||
| automatically update links without opening file | Excel Worksheet Functions | |||
| Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
| Update multiple workbooks automatically | Excel Worksheet Functions | |||
Linear Mode
