I have just been a presentation done by someone external to my organisation.
As part of the presentation I was shown a template which had features I
wanted to know how it can be done.

Feature 1:
A list of products from various suppplier was in one worksheet
The data may look like this:
Product A Supplier 91212 Amount $52
Product B Supplier 91212 Amount $50
Product A Supplier 91285 Amount $55

In a another worksheet:
If you type Product A in, it will return a list that matches Product A:
Product A Supplier 91212 Amount $52
Product A Supplier 91285 Amount $55

How do you get it to return you a list when you type in the product?

Feature 2:
The data may look like this.
Product A Supplier 91212 Amount $52
Product A Supplier 91285 Amount $55
Product B Supplier 91212 Amount $50
Product C Supplier 91212 Amount $150

A chart is created based on the above information. However, you have the
option to choose which product you want included in the chart just by putting
Yes next to the record. How is this done?

I would really like to find out how the 2 features is done, because it will
help me with another task that I'm doing. Thanks.