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

  • Thread starter Thread starter Mcneilius
  • Start date Start date
M

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
 
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
 
Back
Top