Intricate dupe-macro question


C

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!
 
Ad

Advertisements

N

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
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top