Intricate dupe-macro question

[carl.w.bailey]

I have 2 columns of data. One column is an account #, the second
column is the amount spent in one transaction. So I have dupes in
column A, values I wish to keep and tally in column B.

I would like to construct a macro that tallies the amount for each
account #, does anyone have any references or sites that could help me
get started with this?

Thanks Much!

 

[Nick Hodge]

Carl

You don't need a macro, just sort the data by Account# and then go to
Data>Subtotals... and apply the subtotals at the change in Account# and use
the Sum function on the Amounts.

Let us know if that works for you?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk