Varied product list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Montana - 27 Mar 2008 20:26 GMT

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 I’d 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? I’m drawing a blank here.

Reply to this Message

akphidelt - 27 Mar 2008 20:43 GMT

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.

> 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
[quoted text clipped - 9 lines]
> Access, but most of my associates that would use this only have Excel. Any
> ideas on how to do something like this? I’m drawing a blank here.

Reply to this Message

Montana - 27 Mar 2008 21:19 GMT

That's not a bad idea. I could still use the check boxes, if I combine them
with if statements. But how do I tie in the filter?

> 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
[quoted text clipped - 15 lines]
> > Access, but most of my associates that would use this only have Excel. Any
> > ideas on how to do something like this? I’m drawing a blank here.

Reply to this Message

akphidelt - 27 Mar 2008 23:30 GMT

The filter would just be a normal filter. What exactly are you trying to do
here. So you want to be able to select a customer and only have the products
that they're interested in show up? And it's impossible to do that without
being able to see the products they don't want. Is there some other action
going on after this or what?

> That's not a bad idea. I could still use the check boxes, if I combine them
> with if statements. But how do I tie in the filter?
[quoted text clipped - 18 lines]
> > > Access, but most of my associates that would use this only have Excel. Any
> > > ideas on how to do something like this? I’m drawing a blank here.

Reply to this Message

Montana - 01 Apr 2008 00:48 GMT

I got the closest to what I was looking for by creating a pivot table. With
it I can de-select certain categories, (such as frozen foods) before I send
it to the printer or email it. The pivot table will allow me to list the
items under a heading (the category name), where the filter listed every
thing together. The drawback to the PT is that it won't repeat the product
description when there is more than one size
of product. So I'm back to the drawing board.

> The filter would just be a normal filter. What exactly are you trying to do
> here. So you want to be able to select a customer and only have the products
[quoted text clipped - 24 lines]
> > > > Access, but most of my associates that would use this only have Excel. Any
> > > > ideas on how to do something like this? I’m drawing a blank here.

Reply to this Message

Rate this thread: