Filter based on two columns

[p45cal]

without copy or move data to another location

On Sheet4 of the attached is a macro solution. It briefly uses cells F1:F2 as criteria for an advanced filter:

Sub blah()
Range("F1").ClearContents
Range("F2").FormulaR1C1 = "=RC4>RC1"
Range("A1").CurrentRegion.Resize(, 4).AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("F1:F2")
Range("F2").ClearContents
End Sub

On Sheet3 there's another solution which does update a result table in another location. Update the source data table on the left, then right-click the result table and choose Refresh.

It really is a good idea to attach your own sample file - you'll get answers more quickly.