I have a data in col a of sheet1 (suppose Party Name in col a). I need code for whenever i go to col a of sheet2 (whatever the cell is select) the list box or combobox appear consisting of data from sheet1 of col a to enter the data in relevant cell of sheet2.

Syed Haider Ali