Create a PivotTable
http://www.ozgrid.com/Excel/excel-pivot-tables.htm




--
Regards
Dave Hawley
www.ozgrid.com
"Rashmi" wrote in message
...
I have data in a sheet with names and amounts due. Like

A 500
B 300
A 600
B 300
C 400
C 200

There is a second sheet named summary. I want the totals of each person to
appear in the summary sheet. These should be linked cells and any change
in
data in sheet 1 should be updtaed automatically