I have a spreadsheet with 2 pages. The first page has 3 columns. Column 1 is the customer name, column 2 is the item purchased and column 3 is the item price. We may have from1 to 100 customers a day, so the list could be somewhat long. I have a second page titled "Autobiography". I would like it to list all the customers who purchased that particular item.
So if Sheet 1 looked something like this:
1. John Doe Chocolate $5.00
2. Jane Edward Backpack $25.00
3. Ann Rand Autobiography $10.00
4. Edd Wynn Autobiography $10.00
5. Jack Jones Pencil Pack $2.00
So the second sheet named "Autobiography" should have a list like the following:
1. Ann Rand
2. Edd Wynn
Total Sold: 2
How do I create the second sheet?
So if Sheet 1 looked something like this:
1. John Doe Chocolate $5.00
2. Jane Edward Backpack $25.00
3. Ann Rand Autobiography $10.00
4. Edd Wynn Autobiography $10.00
5. Jack Jones Pencil Pack $2.00
So the second sheet named "Autobiography" should have a list like the following:
1. Ann Rand
2. Edd Wynn
Total Sold: 2
How do I create the second sheet?