fetching values from sheet1 and putting in drop down list in sheet2

[szpt9m]

Hi All,

I have 2 sheets: sheet1 and sheet2

in sheet1 the values will be like this:

Please Login or Register  to view this content.

in sheet2 column A will have drop down with Alfa and Numeric values. and in column B based on the selection in column A it should display Alfa or Numeric values in drop down.

like for eg:

if i select Alfa in A1, then in B1 it should show A,B,C,D in drop down list. These values(A,B,C,D or 1,2,3,4) will be fetched from sheet1 and can be changed anytime.

Please help.

Thank you.

[Ace_XL]

This might help

www.contextures.com/xlDataVal02.html

[szpt9m]

This might help

www.contextures.com/xlDataVal02.html

Thanks it worked!!