Hi

Suppose I have the following entries in 2 columns in a data sheet 1:

Sony Sony 1
Panasonic Panasonic 1
Sanyo Sanyo 4
Sony Sony 2
Sony Sony 3
Panasonic Panasonic 2
Sanyo Sanyo 1
Sanyo Sanyo 2
Sanyo Sanyo 3


Question 1:
How do I setup a drop-down field on another sheet 2 so that it only shows me
unique options from col A (i.e. only shows three options of Sony, Panasonic,
and Sanyo)?


Question 2:
In sheet 2, after I have selected one of the unique options from the
drop-down as above, I want to have a drop-down in the next column that only
gives me related options from col B of the datasheet... so if I pick Sony
from the first column dd, the only options in this second dd are Sony 1, Sony
2, and Sony 3. How do I do this? I also need the option to add new values
in this column if it doesn't already appear in the dd.

Thanks in advance

Arjay