Filtering data and posting results to another sheet

I would like a macro asking for “beginning” and “ending” dates, then asking for “Car Make”

Based on the result, on sheet2, starting on cell B6, show the result, which would include: the Make, Date, Region No, S or H, and the number sold, along with the total, but not to show zero or empty cells.

Allow the user to edit sheet2 (highlight, comment) print it, clear contents, etc.

Can any such macro, then retain the dates (until the workbook is closed), so if the macro is called again, it would ask “In the same period, what Make would you like to report on” and then repeat the process.

Hi Jaslake,

Thanks for the code.

I press the "Make Selection" button and choose a start date and end date then model, when I press the "Extract Data" button, I get a dialog box asking again for Start Date. If I repeat the process, I get the same dialog.

What do you think??

Keith

Hi Again,

Yea /no, I get it on the data / file you sent back to me, downloaded and saved.

Good Morning,

I did as you suggested and placed a breakpoint on the "With Me" line and pressed the button, I then pressed the F8 key and stepped through the code. The code goes through the MsgBox and then displays the message "Please enter a Start Date".

If I REM that block of code it does the same again for the end date "Please enter a End Date", if I REM that bit of code also it runs fine, suggesting that the date is the problem.

Please Login or Register  to view this content.

I noticed that although I select, say, 15/01/2014 the dialog would display 1/15/2014. Not knowing what I am doing, I changed the below code from

Please Login or Register  to view this content.

TO

Please Login or Register  to view this content.

This displayed my selection correctly but then I get a dialog "No cells were found"

Regards,
Keith

My Regional Setting are English UK

Thank s very much.......I await the outcome. Also, is there any chance that you could add some comments to your code as I'd like to "try" and understand it a little and try to learn from it.

Cheers,
Keith

I have done some testing and it seems to be working perfectly and as I required. Thank you for your time and effort, I do appreciate it. Thank you also for the annotation, I will study it but it still looks like a "foreign language" to me.