What function would I use?

[Capn_Chord]

Thanks for the suggestion it did work really well, but I
think I'm dealing with a little too much data for it.

This is an example of what I'm trying to do.


Product 1
--------------------------------------------------------
Customer name | accesorie a |accesorie b| accessorie c |
--------------------------------------------------------
Bob | yes | | |
--------------------------------------------------------
Mary | | yes | |
--------------------------------------------------------
John | | | yes |
--------------------------------------------------------


This is a very small example of the worksheet where I do
the data entry. I hav seven worksheets like this one.
Basically I have seven major products that people
purchase and they purchase accessories a,b,or c along
with those. I need for this to search through the seven
worksheets and pick out only the people who bought
accessorie A and put them in a list by themselves like a
report. In theory it should group everyone who bought A
together in one list and everyone who bought b and so
forth. Then this should all print out on one sheet.

Thanks again for any help that can be given.

 

[AlfD]

Hi!

I suggest you try Data> Filter > AutoFilter.

Al

 

[Capn_Chord]

Thank you, but that was the suggestion I was refering to
in my previous thanks. That didn't seem to do what I
needed.

 

[AlfD]

Hi!

Two questions:

How big is your database?
What makes you say that AutoFilter doesn't work? (e.g. what goes wrong/where/when)

Alf

 

[Capn_Chord]

I have seven product lines that I sell. So I have seven
worksheets to keep track of each. On each worksheet I
have room to log 30 customers and for each customer there
are 15 or so entries for Name, purchase #, money source,
etc. Five of those are for 5 different accessories that I
can sell on each product line.

What I'm trying to make is a commission sheet that takes
the customers that bought the accessories and lists each
of them.

The problem that I ran into with the auto filter, is that
I must list the customer once for each accessory that
they buy. If I have 3 people who bought accessory A and
five people who bought accessory B, when I did the filter
based on column a it would not show all of those in
column B. I might just be using the command wrong, but it
wasn't turning out how I needed it.