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.