select dropdown list dependant on value of a given cell
 

Can anyone tell me how i can select a dropdown list dependant on value of a
given cell or in otherwords display different dropdown lists dependent on the
value previously entered or displayed in another cell.

select dropdown list dependant on value of a given cell
 

So you want a dependent list using data|validation?

See Debra's site again!
http://contextures.com/xlDataVal02.html

abo wrote:

Can anyone tell me how i can select a dropdown list dependant on value of a
given cell or in otherwords display different dropdown lists dependent on the
value previously entered or displayed in another cell.

--

Dave Peterson

select dropdown list dependant on value of a given cell
 

Debra Dalgleish show how he

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

Hope this helps.

Pete

On Jul 2, 4:02 pm, abo wrote:
Can anyone tell me how i can select a dropdown list dependant on value of a
given cell or in otherwords display different dropdown lists dependent on the
value previously entered or displayed in another cell.