Excel Macro - Can this be done ?

[Thor]

Hello all. I have a question about excel macros. This is a bit more
complex than the average. I want develope a macro that is linked to
another spreadsheet that then links to a like field and then performs
a calculation. Currently I am importing the files in to MS Access and
then creating a relationship and exporting a combined file, then
performing a calculation. Is thier any hope ?

 

[Tom Ogilvy]

Sounds like it could be done using worksheet functions and wouldn't need an
macro.

 

[Ken Wright]

Workbook Functions that would probably do this are a combination of any of the
following (Not an exclusive list by any means):-

SUMPRODUCT()
VLOOKUP()
INDEX()
MATCH()
OFFSET()

Post more details and you will get more detailed responses.