Hi,

At work we use Excel as a way to order meals. However, it's basically a
glorified Word Document. How it works now is that we open the
"Menu.xls" file and the stock codes are in the first cell and the
description of those stock codes are in the adjacent cells.

For example:

7218415 - Bacon & Scambled eggs (3) - White toast (2) - c/w home fries
7218423 - Bacon & Scambled eggs (3) - Whole Wheat (2) - c/w home fries
<etc.

So, what we do is scroll down the spreedsheet and write down the stock
codes to the parts of the meal we want (dessert, drink, soup salad,
etc.). And then we give these 5 or 6 handwritten stock codes to our
boss who uses them to order the completed meal. Aside from being really
inneficient, you often end up with the wrong meal because you've
mispelled a stock code or two (or your boss mis-types the stock codes
when he orders the meal).

What I would like to do is be able to select the stock codes from a
drop-down box and then be able to print the final selection, but I'm
not sure if that is possible with Excel.

Is this possible? If not, is there a way that the user could easily
select or deselect several stock codes and then switch to an alternate
view where only those items that were selected are viewed? For example
could they be presented with a series of radio buttons or checkmarks
that they could click and then click something else to see only the
items they had selected? Then, they could print (or email) this
"selected" view.

I would really appreciate any advice you could give me about this
problem.

Thanks.

~ Jamie West