How to return multiple results in a cell

V

Vinod

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
 
F

FSt1

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
 
V

Vinod

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.
 
F

FSt1

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

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to open a designated sheet in a separate file 2
Refering to a particular cell in a Named Range 3
How to reference a cell depending on the value in another cell?? 4
Excel Help (Excel): How to add same cell in multiple workbooks? 0
formula to find the data of a next cell in a list 2
RENEWED-- Arrays: Counting multiple values within array 5
Identify precedents to cell in/outside of activesheet 1
how to extract data from a cell in a formula in another cell 1

Top