sorting data from worksheet 1 to worksheet 2

**TigerMom** · 09-27-2011, 10:18 PM

I am trying to create a clerking spreadsheet for a small charity auction. The basics of entering the item, cost and buyer # & a list of buyer numbers where I am able to keep a running total of each numbers purchases is in worksheet 1 (renamed Clerk Sheet). This part I have been using for a few years.

I would like to be able to print a sheet for each customer showing what they purchased & the cost. I have set up sections on worksheet 2 (renamed Customer Totals), but have been unable to figure out how to get the data over.

I need look in Clerk Sheet, column C for the Buyer # copy the item & cost to the appropriate area in Customer Totals.

I am attaching the blank worksheet. I have tried using VLOOKUP with disappointing results.

**MarvinP** · 09-27-2011, 10:40 PM

Hi TigerMom and welcome to the forum,

If I was doing this problem I'd do it with a pivot table and a filter. See sheet3 of the attached.

I hope this helps on what you need.

**jaslake** · 09-27-2011, 10:47 PM

Hi TigerMom

Welcome to the Forum!

Are your headers reversed in Columns B and C of "Clerk Sheet"?

**TigerMom** · 09-28-2011, 01:06 PM

Marvin P

Thanks so much! This looks like it should work perfectly. I have never really worked with PivotTables before and would never have thought to try it. I was near pulling my hair out trying to get something to work before I found this forum. I will give this a try!

Thanks for the quick response.