This will not solve my problem, (my fault for not putting in a good
enough description :-p )

I have 2 Sheets:

Sheet 1: List that I previously described
Sheet 2: A list with a couple of hundred lines with the following
columns:

A) Species (ALREADY POPULATED)
B) Kingdom (NOT POPULATED)
C) Phylum (NOT POPULATED)
D) Class (NOT POPULATED)
E) Order (NOT POPULATED)

For columsn B-E I want to have a drop down in each, that is
predetermined by the column to the left of it. (the column B dropdown
will just have the 5 kindoms)

Hopefully this makes my question a little clearer.

Thanks!


Dave Peterson wrote:
> That should be:
> data|Filter|autofilter.