Extracting entries from large list

[wbgill]

I have a rather large list of customers for our non-profit (almost 700 names) and it is set up to keep track of this years purchases of six different products. The products are in different columns and contain just one number to indicate number of items purchased. They may have purchased one or all six items.

I am trying to find an efficient way to extract this years customers and purchases and create a list that I can take to our distribution site to keep track of who has shown up and what they should be receiving.

There has to be an easy way to do this, but I haven't found it yet. I would appreciate your help!

Thanks,
Bill

[tlafferty]

Have you considered using a pivot table report? Post a sample of your book and I'll take a look.

[wbgill]

Not very familiar with Excell unfortunately. I use it several times a year for this and similar products.
Thanks for looking!