referencing another excel document

[smith_ts]

Hi again,

Ok, a little bit more complicated this time....

So i have a master excel document which is updated automatically with data from various sources (not by me, by someone much cleverer!!). This would be saved in a static location and not moved.
I want to create a new and separate excel document which references the other document. Is this a Macro?

Now its get a bit more tasty....

On the new document I want to reference specific cells on the master document.
The cells exact location may change so would need to lookup specific x & y axis headings.
Eg
Sales Calls
Barry 5 1
Steve 10 3
Phil 7 4
I would need to reference "Barry" & "Calls" to retrieve the figure "1".

I'm pushing myself here but life isn't supposed to be easy!!!

[ChemistB]

You'll need to use the INDEX and MATCH functions.
Let's say your workbook with your data is called ReTable.xls and names are in A2:A4, sales and calls are in B1:C1 with your data in B2:C4.
In your new workbook, you have Barry in A1, and Calls in B1. In C1

Please Login or Register  to view this content.

Does this work for you?

The first MATCH finds out what row Barry is in your data and the second looks at Sales or Calls.

[smith_ts]

works a treat. Thank you!!