All2Cheesy
Board Regular
- Joined
- Mar 4, 2015
- Messages
- 127
Hi all,
I need to create a macro which allows for the current data on screen (in this case freight) to be filtered by where it is going, and also where it is coming from. The code to do this is below, however, I can only ever do one or the other. Would it be possible to have my spread sheet filter by 'criteria 1' OR 'criteria 2'?
Many thanks in advance.
I need to create a macro which allows for the current data on screen (in this case freight) to be filtered by where it is going, and also where it is coming from. The code to do this is below, however, I can only ever do one or the other. Would it be possible to have my spread sheet filter by 'criteria 1' OR 'criteria 2'?
Code:
Sub SYDRETURN()
'Show Sydney
Range("A6:I549").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("B4:B5"), Unique:=False
Range("A6:I549").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("AB4:AB5"), Unique:=False
End Sub
Many thanks in advance.