Hi, want to create a macro to filter all cells in column K, which include the word "VAT Return".
The name vat return will be part of a string: For Exampe: Q1 2019 VAT return, or Q2 2019 Vat return.
Sub filtering
rows("1:1").select
selection.autofilter
activesheet.range("k4:k100").autofilter field:=1, criteria1:= "VAT Return", operator:=xlor
end sub
The name vat return will be part of a string: For Exampe: Q1 2019 VAT return, or Q2 2019 Vat return.
Sub filtering
rows("1:1").select
selection.autofilter
activesheet.range("k4:k100").autofilter field:=1, criteria1:= "VAT Return", operator:=xlor
end sub