Filter data based on data in textboxes in userform and move to a new workbook

Hello,

I have a userform with a monthview that populate it's value in a textboxes.

How can i filter the data based on the dates on the textboxes and then move it in a new workbook?

For ex: textbox1 = 03/01/2014 and textbox2 = 03/02/2014, then the data will be filtered only on that date and then move it in a new workbook.

I've attached my file

Thanks in advance.

Can anyone help me on this please?

Hello Gurus,

can anyone help me on this please

Please help

Hi jaslake,

Basically the textboxes in the userform will indicate the date (timestamp field in Sheet1) to be filtered.
For example, textbox1 is "03/01/2014" and textbox2 is "03/02/2014" then the "Generate" button will perform:

1. Filter range B & C of sheet1 according to the value of textbox1 and textbox2
2. After filtering, copy the filtered data in a new workbook.

Hi jaslake,

Thanks for that, but needs a little modification, basically the value of the textbox1 (from) and textbox2 (to) is come from the user. What i mean is, the user choose the date by pressing the 'Calendar1' button and 'Calendar2' button and data will be filtered on that date.

I've attached the modified template.

Hi jaslake,

I'm attaching the file.