Many filter conditions

[omaoma]

Hello,
I have an Excel table with all parcels sent in Europe all year. I want to filter them using an userform in order to select only the parcels sent in April 2013 in Paris and to make a report with the selected range on a new sheet .
Thank you!

[Harribone]

Attached should do what you require.

[snb]

I think you are better off with a pivottable:

[omaoma]

I wanna thank both of you for your answers. Unfortunately I didn't explain very clear what I wanted. I want to make a user form with 2 text boxes with the filters and an Ok buton in order to select some rows from a sheet and put them in another sheet. I hope you will help me to do it this way.

[Charles]

Hi,

This seems to be the same question as
http://www.excelforum.com/excel-prog...her-sheet.html

It has a Input Box for the date that you want to filter.
As for the Userform. You can have a "List Box" that show the filtered "Date" and from the selection of the date have it filter the
Data and send the result to the List sheet.
Now why 2 text boxes on the userform. Are you sure thats what you want. Provide a better detailed info.

[omaoma]

Hello ,
You are right, it' about the same question. I wanted two boxes on a userform and I didn't know how to use a userform in Excel. In the meantime, I've learned..
THank you all for for your support