Hi,

Create a pivot table. Drag, date, from and acct. to the row field area and
amount to the data field area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"nidabland" wrote in message
...
I have a database that contains a lot of bank deposits. I need to create
a
new spreadsheet that will automatically add up the amounts of the deposits
by
the originating bank account #.For example
Date From Acct. Amount
3/5 MS 23 500
7/8 SK 2 300
8/9 MS 23 200

I need to create a new spreadsheet that will be able to pick up the
different acct transactions and combine them into one total and
automatically
update whenever I need to add a new transaction. The new spreadsheet
should
look like
From Acct. Amount
MS 23 700
SK 2 300

and then if I were to add a new transaction on 8/10 to MS acct. 23 for
500,
the other spreadsheet would automatically update to 1200 without me having
to
do anything. Is this possible? Sorry for the long explanation.