I've been playing with this macro for most of today. I have gotten it to look for one specific date and copy the row based on that day and if it matches "maintenance" on the 9th column but am now trying to get it to copy rows over a range of dates. Am I on the right track here?

Here is my code:

Sub Exercise()
'Determine Start Date and End Date
Maintenance Looper2.xlsm
Dim startDate, endDate As Date
Cells(2, 1).Select
Calender.Show
startDate = Cells(2, 1).Value
Cells(2, 2).Select
Calender.Show
endDate = Cells(2, 2).Value
Cells(2, 4).Value = endDate
Cells(2, 3).Value = startDate
''''''''''''''''''''''''''''''''''''''
Application.Run "testdata"
End Sub
Sub testdata()
Sheets("Line 1").Select
Dim i, LR As Long
Dim Reason As String
Reason = "Maintenance"

LR = Sheets("Line 1").Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

For i = 1 To LR
Columns("B:B").NumberFormat = "mm/dd/yyyy"
If Cells(i, 2) = startDate Then
Do Until Cells(i, 2) = endDate
If Cells(i, 9) = Reason Then
Rows(i).Offset().Copy Sheets("Sheet2").Cells(Rows.count, 1).End(xlUp).Offset(1)
End If
Loop
End If
Next i
End Sub