create report in another sheet

[GUS]

The question that jean gave it was write but i want to do this with vba.
The question is...

i have a worksheets which contains customers and th books the bought
example:
customers books Qty
1 jim java book 23
2 karter asp book 45
3 jim java book 44
4 james vba book 32
5 james vba book 12


i want to make a report at another sheet with unique customers and the sum
of all the books that they have bought

example

1. jim java book 67
2 james vba book 44
etc.
P.S if one customer has bought two diferent books (vba,java)
he must be listed in two lines.
Thanks in anvanced

 

[Frank Kabel]

Hi
you may use a pivot table for this. this would create your report
nearly automatically. See the following
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
to get some starting information