I did try to start this project with what VBA knowledge I know, but got stuck.
Sub DeleteRows()
'Declare Variables
Dim ws As Worksheet
Dim myutc As Range
Dim sutc As String
Dim eutc As String
Dim sminutes As String
Dim eminutes As String
'Setup variables
ThisWorkbook.Worksheets("530-590").Range("B1").Value = "Test"
Set myutc = Range("A7:A21")
'Ask for UTC Time
sutc = InputBox("Enter in Start UTC", "SDR Logging Sheet")
eutc = InputBox("Enter in End UTC", "SDR Logging Sheet")
'Ask for Minutes
sminutes = InputBox("Enter in Start Minutes", "SDR Logging Sheet")
eminutes = InputBox("Enter in End Minutes", "SDR Logging Sheet")
Debug.Print sutc
Debug.Print eutc
Debug.Print sminutes
Debug.Print eminutes
'Delete unwanted rows
With myutc.Delete
.EntireRow
End With
'Highlight minute cells in yellow
'Code Cleanup
MsgBox ("Completed")
End Sub
Any help would be very helpful!
Thanks