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

Try to look on Debra Dalgleish site,


http://www.contextures.com/tiptech.html

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Vinod" escreveu:

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

hi
sounds like you are talking about dependent combo boxes, sometimes called
cascading combos.
but you didn't specify as to wheather you are using data validation or
sheets combox box controls or form controls. since you are refering to cells,
i assume that you are using data validation.
see this site for data validation.
http://www.contextures.com/xlDataVal02.html
see this site for sheet combo boxes
http://www.mrexcel.com/archive/Controls/30062.html
http://www.contextures.com/xlDataVal10.html

regards
FSt1

"Vinod" wrote:

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

Thanks FSt1 for providing related links.

Yes your assumption was correct, I am using data validation.
I got the solution from one of your links and that solution is ok if the
countires are in sorted order (as per my example).

Is there any solution if countries are not in sorted order and the countries
are existed in disorder (if we don't have rights to change that particular
source sheet - sheet1 from my example)

If it is possilble in the above scenario without VBA, please direct me
through the solution process.

Cheers
~Vins

Once again thanks for your immediate response.
"FSt1" wrote:

hi
sounds like you are talking about dependent combo boxes, sometimes called
cascading combos.
but you didn't specify as to wheather you are using data validation or
sheets combox box controls or form controls. since you are refering to cells,
i assume that you are using data validation.
see this site for data validation.
http://www.contextures.com/xlDataVal02.html
see this site for sheet combo boxes
http://www.mrexcel.com/archive/Controls/30062.html
http://www.contextures.com/xlDataVal10.html

regards
FSt1

"Vinod" wrote:

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

hi
which link did you use?
i was unaware that the dependent lists had to be in order???

regards
FSt1

"Vinod" wrote:

Thanks FSt1 for providing related links.

Yes your assumption was correct, I am using data validation.
I got the solution from one of your links and that solution is ok if the
countires are in sorted order (as per my example).

Is there any solution if countries are not in sorted order and the countries
are existed in disorder (if we don't have rights to change that particular
source sheet - sheet1 from my example)

If it is possilble in the above scenario without VBA, please direct me
through the solution process.

Cheers
~Vins

Once again thanks for your immediate response.
"FSt1" wrote:

hi
sounds like you are talking about dependent combo boxes, sometimes called
cascading combos.
but you didn't specify as to wheather you are using data validation or
sheets combox box controls or form controls. since you are refering to cells,
i assume that you are using data validation.
see this site for data validation.
http://www.contextures.com/xlDataVal02.html
see this site for sheet combo boxes
http://www.mrexcel.com/archive/Controls/30062.html
http://www.contextures.com/xlDataVal10.html

regards
FSt1

"Vinod" wrote:

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

Hi,

its 'Dependent Dropdowns from a Sorted List' hyperlink from
http://www.contextures.com/xlDataVal02.html


"FSt1" wrote:

hi
which link did you use?
i was unaware that the dependent lists had to be in order???

regards
FSt1

"Vinod" wrote:

Thanks FSt1 for providing related links.

Yes your assumption was correct, I am using data validation.
I got the solution from one of your links and that solution is ok if the
countires are in sorted order (as per my example).

Is there any solution if countries are not in sorted order and the countries
are existed in disorder (if we don't have rights to change that particular
source sheet - sheet1 from my example)

If it is possilble in the above scenario without VBA, please direct me
through the solution process.

Cheers
~Vins

Once again thanks for your immediate response.
"FSt1" wrote:

hi
sounds like you are talking about dependent combo boxes, sometimes called
cascading combos.
but you didn't specify as to wheather you are using data validation or
sheets combox box controls or form controls. since you are refering to cells,
i assume that you are using data validation.
see this site for data validation.
http://www.contextures.com/xlDataVal02.html
see this site for sheet combo boxes
http://www.mrexcel.com/archive/Controls/30062.html
http://www.contextures.com/xlDataVal10.html

regards
FSt1

"Vinod" wrote:

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