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

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