Hi All,

I have an issue with my designing template, please help me out.

I'm having a workbook which contains data in sheet1 as Countries and sales
man names.
US Smith
US Legrand
US Iren Wash
UK Glen
UK Paul
German Neil

My requirement in sheet2 is:
#1)A1 cell should dispaly a dropdown saying that unique countries list from
sheet1
#2)B1 cell should display a dropdown saying that sales persons list of the
selected country (A1 cell of sheet2).

It would be appreciated for the people provides the solution with VBA and
Without VBA.

Advanced Thanks
~vins