How do I link data from another workbook using a different file na

V

Victor

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.
 
C

CLR

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
 
Top