| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking workbooks when source data moves
I need to be able to link two workbooks so that the source data updates the
destination workbook. The second issue is that my source data moves, as information is added and removed, as well as sorted. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking workbooks when source data moves
On Dec 30, 2:40*pm, JohnsMom
wrote: I need to be able to link two workbooks so that the source data updates the destination workbook. *The second issue is that my source data moves, as information is added and removed, as well as sorted. *Can this be done? Use lookup formulas. VLOOKUP, INDEX/MATCH, etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking data within several Workbooks | Excel Discussion (Misc queries) | |||
| Linking data across workbooks | Excel Worksheet Functions | |||
| linking to external dbf data source | Excel Discussion (Misc queries) | |||
| Linking One Source to Two Workbooks | Excel Worksheet Functions | |||
| linking data with other workbooks | New Users to Excel | |||
Linear Mode
