Excel Macro Query - Search for specific text in cells of a column

[Mcneilius]

Hi all

I'm new to this site and I wondered if anyone could help me with th
following query:

I have a financial spreadsheet with expenditure types in Column
(specified from a drop down list) and a corresponding transaction dat
(Column B) and amount (Column C).

What I would like to do is use a macro to "look" down column A and fo
every occurence of a particular transaction type in the drop down list
add the corresponding monetary values together and put then in a cel
for that particular month. For example, all the "petrol" expenditur
for October is added together and pasted into another table for th
given month.

Can a macro do this easily and what macro functions would I use? I ha
my eye on VLOOKUP, but I'm not sure it can cope with multiple occurence
and so on. I have limited experience with macros, so any example cod
would be great!

Any help would be greatly appreciated.

Many thanks

Nei

 

[Frank Kabel]

Hi
I would not use a macro for this. you may either consider using a pivot
table or SUMPRODUCT for adding your values. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


and
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Mcneilius]

Hi Frank, thanks for the prompt reply.

The links look excellent and I will certainly read up on them. I di
have using macros in mind, as I'm a bit more confident with them, s
I'd welcome any further suggestions people may have.

Thanks again

Nei