I don't want use both options.I need a formula,or vba procedure to achieve
the results.
somewhere in 2007 the same type of question was answered by T.Valko,I am not
finding that link file.

"KC Rippstein" wrote:

You should do one of two things. Either:
- apply an auto-filter or advanced filter to sheet 1 and eliminate sheet 2
altogether, or
- use a pivot table on sheet 2
you'll have to add another column to sheet 1 which gives the month &
year from your date column (so make column D labeled "mo-yr" and have this
formula in that column =b2 then format it as Mmm-yy)
set up the pivot table with the sales person's name and the mo-yr in
the Page area and the transaction date in the row area
then you can filter the pivot table by person and month/year using the
Page fields
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"TUNGANA KURMA RAJU" wrote:

my w/sheet1 data looks like this.
Col A--------------------ColB--------------------ColC
SalesMan---------------Date--------------------Amount
Raj -------------------01/Mar/09---------------500.00
Jones-----------------01/Mar/09---------------235.oo
Mary------------------02/Mar/09---------------190.00
Mary------------------03/Mar/09---------------100.00
Raj--------------------03/Mar/09---------------290.00
Cathy-----------------04/Mar/09---------------400.00
Raj--------------------30/Mar/09---------------500.00
Jones------------------30/Mar/09---------------450.00
Raj---------------------01/Apr/09---------------100.00
Mary-------------------02/Apr/09---------------450.00
the list goes on.........
output on w/sheet2 be looks like this:
Col A--------------------------Col B(drop down lists in cell a1 and B1)
Mary--------------------------Mar-09
Date--------------------------Amount
02/Mar-09--------------------190.00
03/Mar/09--------------------100.00

"TUNGANA KURMA RAJU" wrote:

I need a function/formula to extract a list of values from a list basing on
two conditions.
I have date wise sales data sales person,date,amount in sheet 1.
In sheet2, if I enter Sheet2!a1=name of salesman and in cell
B2=month-year(I have drop down list viz.salesmem list,month-year list.)
I need date wise sales details of that salesman , of the specified
month, to the w/sheet range A2:B32.