This seems like a perfect project for access. If you don't know VBA this
would be a difficult task. The best advice I can give you is to use a
numbering system instead of check boxes. Like put -1 if they like a certain
product and 0. Then you can filter or create a pivot table and search by
customers names and only show the products that have -1 on them.

"Montana" wrote:

I need to create a price list in Excel of our product line, but I need to be
able to modify its contents to particular customer types. For example, our
line includes frozen foods, candy, condiments, produce, non-food items, etc.
Certain customers have no interest in our frozen foods and our produce, for
example, so I would like to be able to generate a price list for these
particular customers adapted to their particular needs. I have entered our
entire product line & have all the unique products grouped, but Id like to
be able to check any number of check-boxes on an index page (where the groups
are all listed) & have Excel populate a list of all the products in that
group, along with a heading for each group on a list page that I could print
& give to customers. I know that this type of issue is better handled by
Access, but most of my associates that would use this only have Excel. Any
ideas on how to do something like this? Im drawing a blank here.