RE: How to return multiple results in a cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • Re: can you make a drop down list in a drop down list?
    ... "_range") and it will pull the appropriate sublist each time the JOBS cell is ... I have attempted to use the Data Validation window in the following ways to ... select "Custom" and put the concantenate function in the function entry ... set up the source lists for validation: ...
    (microsoft.public.excel.misc)
  • Re: Data Validation List from a Dynamic Named Range on Another Wor
    ... longer work and I can't just add a value to any cell in the column and have it alphabetize it. ... Take a look at a tutorial I wrote on using INDEX rather than OFFSET as a means of creating dynamic named ranges in situations where you want to used dependent drop downs lists. ... The first is where the data will be used and viewed, the second is where the lists reside that the data validation draws from. ... If Target.Count> 1 Then GoTo exitHandler ...
    (microsoft.public.excel.worksheet.functions)
  • Data Validation List from a Dynamic Named Range on Another Workshe
    ... the second is where the lists reside that the data validation draws from. ... cell based on the first cells validation answer. ... The formula I'm using on the second worksheet, called "Lists" is... ... If Target.Count> 1 Then GoTo exitHandler ...
    (microsoft.public.excel.worksheet.functions)
  • Re: comboboxes
    ... This technique shows how to create dynamic dropdown lists in VBA. ... Combobox Version ... Data Validation Version ... Dim cell As Range ...
    (microsoft.public.excel.programming)
  • RE: Filesize: embedded data validation lists all stored independen
    ... I appreciate your insight into the way the data validation lists use memory - ... stored in each cell, just a reference to their source. ...
    (microsoft.public.excel.misc)