1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| 'criteria on effective date
Scriteria = "<" & Sropdate
Selection.AutoFilter Field:=IvPv_Cash, Criteria1:="PV", Operator:=xlAnd
Selection.AutoFilter Field:=IvEff_dt, Criteria1:=Scriteria, Operator:=xlAnd
Selection.AutoFilter Field:=IvVal_dt, Criteria1:=Scriteria, Operator:=xlAnd
'copying the data if the selection is not empty
'the instruction below list only the data without title
Set Rfilterdata = Wadjust.AutoFilter.Range
Set Rfilterdata = Rfilterdata.Offset(1, 0).Resize(Rfilterdata.Rows.Count - 1)
If Application.Subtotal(3, Rfilterdata.Columns(1)) > 0 Then
Rfilterdata.Copy |
Partager