Dear Expert,

I am creating a reporting format in excel. I am finding it difficult to
make a drop down cells dependent on the other cell value.

e.g. In one column i already defined a drop down list of some stages. I
need one more drop down list in other column which will be dependent on the
selection of the text in first drop down list. How do i go about this. Is
there any solution in excel for this.

Rgds,
Manish