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.

  With Me
    If .ComboBox1.ListIndex = -1 Then
      MsgBox "Please enter a Start Date"
      GoTo EarlyExit

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

Private Sub ComboBox1_Click()
  Me.ComboBox1.Value = Format(Me.ComboBox1.Value, "m/d/yyyy")
End Sub

TO

Private Sub ComboBox1_Click()
  Me.ComboBox1.Value = Format(Me.ComboBox1.Value, "dd/mm/yyyy")
End Sub

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