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

--
Regards,
Tom Ogilvy

"Thor" wrote in message
om...
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 ?