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

A way to do it is to use "Autofilter"

Select the entire sheet, turn on Autofilter, go to the column containing the
data, and set up a filter that looks for the cells that contain "medical".

Then copy and paste the displayed records

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

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