Hi,
I have sheet2 which is taking a direct linked data from sheet1

What I want to achieve is as follows:

First delete rows based on values in certain range of cells.
The VBA i use is as follows with a form-control button:

Option Explicit
Sub DeleteRows()
Dim ChkRange As Range
Set ChkRange = Range("C4:C188")
Dim cell As Range
For Each cell In ChkRange
    If cell = "0" Then
        cell.EntireRow.Delete
    End If
Next
End Sub
secondly I also want to sort all rows based on values ( time) in cells F4:F188 ( lowest value first .....)
However the first action has removed certain number of rows having 'Zero' value.
I want it also to ignore any blank cells while sorting so that they do not interfere.
I can manually do this as well.

I need to combine both above in kind of change event, where any updation of data on sheet2 ( which is linked) will trigger change event to delete rows having Zero value and sort them.

I have tried various methods, but no success.

Any help please..
Many thanks
regards