?
Solved

Excel 2010 DROP DOWN LIST (filtered, sorted)

Posted on 2012-08-31
2
Medium Priority
?
901 Views
Last Modified: 2012-09-01
Hi experts,

I need help to find solution for the folowing problem:

I have created Excel workbook with 3 (three) worksheets:

1. Sheet1 (registration for particular sport Event)
    <Column A> |  <Column B>    |<Event1>| <Event2>
   --------------------------------------------------------------------------------------
    FirstName1 |  SecondName1  |         -     |  Event2
    FirstName2 |  SecondName2  |  Event1  |       -      
    ...                    |  ...                     |  ...          |   ...
    FirstNameN |  SecondNameN |  Event1  |  Event2  

2. Sheet2 (name = "Event1")
              <Column A>                          |  <Result>
   ----------------------------------------------------------------------------
   FirstName2 & " " & SecondName2  |
   FirstNameN & " " & SecondNameN |

3. Sheet3 (name = "Event2")
        <Column A>                                | <Result>
   -----------------------------------------------------------------------------
   FirstName1 & " " & SecondName1  |
   FirstNameN & " " & SecondNameN |

WHAT I NEED is drop down list in <Column A> of Sheet2 and Sheet3 with folowing conditions:
a) Drop down list must be filled with values from two columns of Sheet1: <Column A> & " " & <Column B>;
b) Drop down list values must be filtered so only those names registered (see Sheet1 ) for particular Event appears;
c) Drop down list Values must be in alphabetical order

Please give ideas, solutions how to solve it in Excel 2010.
0
Comment
Question by:Krukanens
2 Comments
 
LVL 18

Accepted Solution

by:
krishnakrkc earned 2000 total points
ID: 38356589
Hi

PFA. I made this in 2007. I hope this would work in 2010 also.


Kris
DropDowns.xlsx
0
 

Author Closing Comment

by:Krukanens
ID: 38357764
Thank You 'krishnakrkc', You really helped me. I think I will add some vb code to automatically refresh pivottables and it would be great.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question