monthly deposits

[penumbra547]

Hi All,

I have a spreadsheet that currently lists all of my clients(by account number) and all of their deposits made to my bank for the past 2 years. However, the clients are listed everytime they made a deposit, so if you can imagine, I have in column A1 many duplicated account numbers. (see attached)

My goal is to use this dataset and create a new worksheet that lists only each account number once in column A1, and then list all the months from Jan '07 to Dec 08 from column B1 to Y1. If account number 518500(See attached example) made a deposit in 11/07 for $329, 12/07 for $360, 12/07 for $50 , 12/07 for $600 (3 deposits in December), and so on, how do I get excel to plot the total deposits per month onto the new worksheet with the month/year listed from B1 to Y1? I'm okay with blanks in the months a certain client didn't make a deposit

Of course, as much automation as possible is ideal because I have over 13000 entries!

Thank You very much!

Frank