suqji 发表于 2021-9-26 08:23
Private Sub Worksheet_Change(ByVal Target As Range)
Dim str As String, sql As String
...
Private Sub Worksheet_Change(ByVal Target As Range)
Dim str As String, sql As String
With Target
Application.EnableEvents = False
If .Value = "" Then
str = "where 业务员='" & .Offset(, 3).Value & "' "
Else
str = "where 客户全称='" & .Value & "' and 业务员='" & .Offset(, 3).Value & "'"
rem sql = "select 客户全称,出货单号 ,sum(未税金额),sum(金额),sum(业务员),sum(差异),sum(税金),sum([差额/佣金]),sum(运费),sum(公司收入) from [8月审单$] " & str & "group by 客户全称,出货单号"
sql = "select 客户全称,出货单号 ,sum(未税金额,金额........,业务员,sum(差异),sum(税金),sum([差额/佣金]),sum(运费),sum(公司收入) from [8月审单$] " & str
rem 把全部sum函数取消试试 显示明细
Range("a4:i" & Application.Max(4, [a65536].End(3).Row)).ClearContents
sql = sql & " union select '合计','',sum(未税金额),sum(金额),'',sum(差异),sum(税金),sum([差额/佣金]),sum(运费),sum(公司收入) from [8月审单$] " & str
end if '改
QueryInfoTo sql, [a65536].End(3).Offset(1)
Application.EnableEvents = True
rem End If
End With
End Sub |