report from sheet

  • Thread starter Thread starter guru
  • Start date Start date
G

guru

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
 
You must log in or register to reply here.

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

Similar Threads

create report in another sheet 1
Combo Boxes getting data from Work Sheet. 4
Help copying last sheet and renaming to next consecutive number 4
How to find No of sheets ,sheet no 2
Comparing two books and two sheets, Problems with color coding correct sheet 1
Total appointments per agent 2
Copy cell (C6) from multiple sheets in a wbook to another workbook 2
Copy paste ranges from multiple sheets 2

Back
Top