Private Sub ListBox1_Click()
ActiveCell = ListBox1.Value
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row > 2 And Target.Column = 4 And Target.Count = 1 Then
Dim A, v, i, d
Set d = CreateObject("scripting.dictionary")
A = Range("c3:d" & Range("d65536").End(3).Row)
v = Target.Offset(0, -1).Value
'统计列表
For i = 1 To UBound(A)
If A(i, 1) = v Then d(Format(A(i, 2), "0.00")) = ""
Next i
'导出列表
With ListBox1
.Left = Target.Offset(0, 1).Left
.Top = Target.Top
.Clear
.List = d.keys
End With
Set d = Nothing
End If
End Sub
副本各车间每日成本费用表8.12.rar
(27.63 KB, 下载次数: 5)