Hi
Quote:
colin,
the no.of.components to be evaluated keeps changing everytime. using a formula to obtain the match volumes will not serve the purpose when the no.of.rows keeps increasing and decreasing.
also the information in sheet2 is not manually feeded. it is downloaded from the web and imported into excel.
i feel more convenient doing this with vba rather than using the formula.
pls assist.
|
Yes, but my suggestion is that you can use VBA to put the formulas into the worksheets. I mentioned before that you would use the Range.Formula() property to do it. This is more efficient than using the WorksheetFunction object to call the functions, not only because the WorksheetFunction is a fairly expensive call but also because the formula approach can be done without looping.