Deleting rows if one cell value is greater than the other.

I attached the file and a pic of the formatting.

Hi, new here. I have been playing with this macro for a week and am now in the final leg of my headache and need help. I came here because everyone seems so smart, quite impressive.

I have a work related macro that I need to delete rows if the value of the cells in column A is greater than the cells in column B. That's it.

The cells are formatted with HH:MM:SS AM/PM, but column A is actually the max allowed time of delivery and column B is the actual duration that took place. The file comes off of the server this way. I'm trying to filter for late deliveries and address them.

Capture.PNG

In this picture once the macro is working all of these rows would be deleted... there is thousands more in the attachment that need to be filtered through everyday.

I think your best bet would be to use mycell.value as follows

For Each mycell In Range("A1:A10000")
'mycell.replace What:="6:00:00 AM", Replacement:="21600"
'mycell.replace What:="4:00:00 AM", Replacement:="14400"
'mycell.replace What:="12:00:00 AM", Replacement:="43200"
If mycell.Value > "4;00:00 AM" Then
'now do replace function
Stop
End If
Next


You may need to format the value string to fit your needs.

Very basic code in the attached.
Essentially it adds a formula to column C to check if A > B and returns TRUE/FALSE.
By filtering to TRUE and deleting those rows, what you're left with are just the FALSE.

Simple but effective.

BSB

I tested it and it worked!

YOU ARE THE MAN!!!

Happy to help

Thanks for the rep point.

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB