Dependant Data Validation List

I want to create a column with a data validation pull down list, the list of which changes dependant upon a value in another cell.

Does anyone know how to do this?

Stabilos, have a look here,

http://www.contextures.com/xlDataVal02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Stabilos" <Stabilos.1yuxfm_1132593901.4362@excelforum-nospam.com> wrote in
message news:Stabilos.1yuxfm_1132593901.4362@excelforum-nospam.com...
>
> I want to create a column with a data validation pull down list, the
> list of which changes dependant upon a value in another cell.
>
> Does anyone know how to do this?
>
>
> --
> Stabilos
> ------------------------------------------------------------------------
> Stabilos's Profile:
> http://www.excelforum.com/member.php...o&userid=28962
> View this thread: http://www.excelforum.com/showthread...hreadid=486901
>