| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
![Thor[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
