I have the following code
Private Sub cmdUpdateSummary_Click()
Dim StartDate As Date
Dim EndDate As Date
StartDate = InputBox("Enter Starting Date Please", StartDate)
EndDate = InputBox("Enter Ending Date Please", EndDate)
End Sub

Can anyone tell me how i can collect the dates in between those entered from
a worksheet and place them on a new worksheet?