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


--
Regards
Frank Kabel
Frankfurt, Germany


Hi all

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

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

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

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

Any help would be greatly appreciated.

Many thanks

Neil


---
Message posted from http://www.ExcelForum.com/