Hi Ali,

Being just a normal user of Excel, can you help write the macro on this.

Best Regards

"Ali" wrote:

Conditional Sum is what you need.
I recommend the Sumproduct function to accomplish this.

"Torpedo" wrote:

Hi ,

I am not sure whether this is doable. I am trying to extract data from some
excel spread sheets created from 2004 to 2009 on a monthly basis.

The field i am trying to consolidate has a keyword " medical" . In some
sheets it is called medical expenses.

The requirement is to find out how much i have spent on medical expenses
every year. Every month there will be 2 or 3 expense claims, created in excel
spread sheet. Unfortunately the Medical expense cell doesn't remain same in
all the spreadsheets.

I got hope after i saw a macro from Joel to Tim on 22 may 2008 on Subject
"Collect data from excel ". But i am unable to edit it as i don't have any
programming knowledge.

If anyone can help me, it would be great

Best Regards
UR