software

Im trying to exctract information from three different excel documents.
I want to query the three documents based on e.g a field called
quot;company namequot; and gather info in a fourth document where quot;company
namequot; is present in all three documents. Is there any way of doing
this, or do I have to do it manually? Or is it possible to merge
documents using parameters to select relevant information? Quite new to
this. Know you it would be better to use a database to do this but do
not have access to one.--
pollymoe
------------------------------------------------------------------------
pollymoe's Profile: www.excelforum.com/member.php...oamp;userid=31045
View this thread: www.excelforum.com/showthread...hreadid=507175you can reference cells in other files using this format:

=[filename.xls]sheetname!A1

that is cell A1 in the other file.

quot;pollymoequot; wrote:

gt;
gt; Im trying to exctract information from three different excel documents.
gt; I want to query the three documents based on e.g a field called
gt; quot;company namequot; and gather info in a fourth document where quot;company
gt; namequot; is present in all three documents. Is there any way of doing
gt; this, or do I have to do it manually? Or is it possible to merge
gt; documents using parameters to select relevant information? Quite new to
gt; this. Know you it would be better to use a database to do this but do
gt; not have access to one.
gt;
gt;
gt; --
gt; pollymoe
gt; ------------------------------------------------------------------------
gt; pollymoe's Profile: www.excelforum.com/member.php...oamp;userid=31045
gt; View this thread: www.excelforum.com/showthread...hreadid=507175
gt;
gt;