Data from Worksheet in another File

[modorney]

How do I get data from a worksheet in another file? I can see how query works for ODBC databases, but I want to reference just a cell on another worksheet in another file.

For example, I want cell B2 in Sheet1 if File1.xls to appear in
cell A1 in Sheet2 of File2.xls
(and this- A1 in Sheet2 of File2.xls - will update when the origin cell is changed).

-- mike [sig][/sig]

 

[dsi]

In destination cell (Cell A1, Sheet2, File2.xls) insert the formula;

=[File1.xls]Sheet1!$B$2

That should do it!
[sig][/sig]

 

[modorney]

Thanks! This worked great!!

-- mike [sig][/sig]