Hi,

Could you please advice how to have the drop down list and the value from other sheet in excel?

I have sheet1 in which its value
A
B
C
D
..........

In sheet2, i want to have those value shown in the drop down list.

Please advice