Excel Macro - Can this be done ?
 

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 ?

Excel Macro - Can this be done ?
 

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 ?

Excel Macro - Can this be done ?
 

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"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 ?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 17/09/2004