Private Sub Worksheet_Activate()
Call 销售清空筛选
End Sub
Sub 销售条件查询()
If Cells(3, 13).Value = "" Or Cells(3, 13).Value = 1 Then
Application.ScreenUpdating = False '关闭屏幕刷新
Application.Calculation = xlCalculationManual '手动重算
ActiveSheet.Range("s13:l65536").ClearFormats '清除格式
Sheets("销售数据").Columns("A:k").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("b3:l4"), CopyToRange:=Range("b13:l13"), Unique:=False
Application.Calculation = xlCalculationAutomatic '自动重算
Range("B13:L13").Select
Selection.AutoFilter
Else
Call 销售清空筛选
MsgBox ("货号错误请查证后重新查询")
End If
End Sub
Sub 销售日期范围筛选()
Application.ScreenUpdating = False '关闭屏幕刷新
Application.Calculation = xlCalculationManual '手动重算
ActiveSheet.Range("s13:l65536").ClearFormats '清除格式
Sheets("销售数据").Columns("A:k").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("c9:d10"), CopyToRange:=Range("b13:l13"), Unique:=False
Application.Calculation = xlCalculationAutomatic '自动重算
Range("B13:L13").Select
Selection.AutoFilter
End Sub
Sub 销售清空筛选()
Range("b4:l4").Select
Selection.ClearContents
Range("C8:D8").Select
Selection.ClearContents
Rows("13:65536").Select
Selection.ClearContents
Range("e5").Select
End Sub