Hi Ed,

Try looking here, lots of info on dependant drop downs.

http://www.contextures.com/xlDataVal02.html

HTH
Regards,
Howard

"Ed" wrote in message
...
Hi,

I've got a problem which is a little difficult to explain so bear with me!

Firstly I'd like do have two drop down boxes which flow through each
other.
So Box One has 1,2 and 3 as options, for example. If Box One selects "1",
Box
Two would offer 1,2,3. If Box One selects "2", Box Two would offer 4,5,6
etc.

Based on the final outcome in Box Two I'd like the cells to the right of
Box
Two to show specific information.

Is this possible? I'm effectively trying to put in a scroll option for a
number of Rows where only the Row currently selected can be seen, to tidy
it
up a bit.

If anyone has any ideas on this it would be greatly appreciated. This is
my
first time on here and there is a wealth of info and it's a great source
of
learning!

Thanks in advance.