| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I link data from another workbook using a different file na
I'm trying to link data from a source workbook to a destination workbook
using a different filename. Also the data will be save in several worksheets. I would like to keep a history of the link data for each worksheet. Which is the best way to execute this task. |
|
#2
|
|||
|
|||
|
This formula, when placed in a cell in your current workbook, will draw the
value from cell A1 of the Workbook1.xls file from the specified directory. ='C:\My Documents\[workbook1.xls]Sheet1'!A1 Vaya con Dios, Chuck, CABGx3 "Victor" wrote in message ... I'm trying to link data from a source workbook to a destination workbook using a different filename. Also the data will be save in several worksheets. I would like to keep a history of the link data for each worksheet. Which is the best way to execute this task. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
| macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
| Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
| hyper link to another workbook | Excel Discussion (Misc queries) | |||
| What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
Linear Mode
