i have a sheet with accoutn head, amount, date

and in my user form combobox1 type of account and
calendar1 from date and calendar2 to date
if i select from combobox1 an item and select from date
and to date i have to get a report of transcation
pertaininig to that period only..

hope my point is clear now

Soniya


-----Original Message-----
How can I select data assuming that my calendar1 is
start date and
calendar2 is end date.

Sorry, but your question is not clear. Could you be
more specific? An
example?


--
Jim Rech
Excel MVP


.

The Data, AutoFilter and Data, Advanced Filter commands can be used to show
data rows that match criteria in place (by hiding non-matching rows of the
database). Advanced Filter can also be used to create a new list of just
the matching rows. If you are not familiar with these commands perhaps you
can experiment with them to see how they work. Then you can record a macro
as you do either type of filter to see the macro syntax. With the online
VBA Help you should be able to write a macro that creates the report you
want.

For more help with filtering you could look at the Contextures web site:

http://www.contextures.com/xladvfilter01.html

--
Jim Rech
Excel MVP