asked on

Excel 2010 DROP DOWN LIST (filtered, sorted)

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.

ASKER CERTIFIED SOLUTION

krishnakrkc

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Krukanens

ASKER

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