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.