Extrating data based on 2 parameters

[javedmati]

Hi,

I have created an excel which has name of employees in rows and name of months (January to December) in columns. Something like this.

==============================
Name Jan Feb Mar ......... Dec
==============================
Emp1 33 66 11 .........
Emp2 23 09 43 .........
Emp3 54 76 98 .........
Emp4 22 98 45 .........

In cell O2, user needs to select the month from the dropdown menu. I want to extract the data from above mentioned table based on user's input in CELL O2.

For e.g. if user selects JAN then I want to extract names of 4 employees and the data of Jan month and paste it somewhere. For e.g. if user selects Feb then the output should be

=========
Name Feb
=========
Emp1 66
Emp2 09
Emp3 76
Emp4 98

User can also select options like Q1, Q2, Q3 or Q4 in CELL O2. If user selects Q1 then data of first 3 months should be extracted and if the user selects Q4 then data of last 4 months should be extracted.

Highly appreciate your time.

Regards
Javed

 

[Akashwani]

Hi Javed,

Have you tried using a Pivot Table? You can use the Report Filters to do as you require. If you don't want to use a Pivot Table, see if this thread helps to point you in the right direction....

http://www.mrexcel.com/forum/showthread.php?t=545679

Or take a look here for some videos....

http://www.youtube.com/user/ExcelIsFun#g/u

If you can post a link to a file you have put on the net, I will take a look at it for you and see if I can offer a solution.

Good look.

Ak