query multiple excel files

[pollymoe]

Im trying to exctract information from three different excel documents
I want to query the three documents based on e.g a field calle
"company name" and gather info in a fourth document where "compan
name" is present in all three documents. Is there any way of doin
this, or do I have to do it manually? Or is it possible to merg
documents using parameters to select relevant information? Quite new t
this. Know you it would be better to use a database to do this but d
not have access to one

 

[Marvin P. Winterbottom]

you can reference cells in other files using this format:

=[filename.xls]sheetname!A1

that is cell A1 in the other file.