Linking workbooks

[Greg]

Need to know how to link two or more MS Excel workbooks so
that data flows from one workbook into the desired
column(s) on another workbook.

 

[Frank Kabel]

Hi
- open both workbooks
- select the target cell
- enter the equation sign '='
- now select with your mouse the other file and source cell
- hit ENTER
- copy this formula