Generating a report based on date range

[hey1000]

Hi there once again,

I have the first userform working pretty good. I know the code is a mess but it does exactly what i am looking for it to do. I have no idea how to clean it up to make it run more efficiently but thats not the issue.

I am looking for code that can generate the report that a user selects.
For example the user clicks reports on the userform. The report userform opens up. The user checks the monthly report button and enters the last day of the month he wishes the report to be for. i.e 7/31/2010 and then clicks generate report. when executed excel creates a new workbook and creates two sheets. the first looks exactly like the master data sheet from the original worksheet but of course with the specified data. the second sheet will populate a summary of the data. I will address that after i figure out how to get the first sheet compiled.

This may sound very confusing, in my head it makes perfect sense but i am so fried from this project that i am not sure if i am explaining correctly.

Any help would be greatly appreciated on this matter.

Thanks

Kev

[pmyk]

Have you succeeded in creating a report?