Greetings.

Thank you for reading this, I hope you can help me.

on worksheet 1 I would like to create 3 drop-down lists.

The first drop-down list displays 66 values (in this case names o
galaxies), values which are in column A on worksheet 2. In column B o
worksheet 2, there is a serial number for each of the 66 names.

Example: on worksheet 2, A1 = "derelik" and B1 = 10000001

Here comes my problem:

On worksheet 3 there is a list of constellations within each galaxy
each constellation has its own serial number (for instance "San matar
which has the serial number "20000001"). So on worksheet 3 there is i
column A the galaxy serial number of the constellation, in column
there is the constellation serial number, and in column C there is th
name of the constellation.

Then in worksheet 4, there are the individual names of eac
solarsystem, their respective serial number (for instance: "EH2I-P
serial: 30005108), the constellation serial which they're in, and th
galaxy serial that solarsystem is in.

So what I want to do is this:

From the first drop-down list I choose the galaxy.

From the second drop-down list I get a choice of _only_ th
constellations within that galaxy.

From the third drop-down list I get a choice of _only_ solarsystem
within that constellation.

Is this possible? If so, can you help me?

Thanks for any replies.

K

--
Message posted from http://www.ExcelForum.com