谢谢!我怎么这么笨!
另:下面的代码,如果要简化,应该怎么写?
Private Sub CommandButton2_Click()
Dim r%, i%
Dim arr, brr
With Worksheets("源数据")
r = .Cells(.Rows.Count, 1).End(xlUp).Row
arr = .Range("b2:e" & r)
ReDim brr(1 To UBound(arr), 1 To 4)
m = 0
For i = 1 To UBound(arr)
If arr(i, 2) = "足金项链" Then
m = m + 1
brr(m, 2) = arr(i, 2)
brr(m, 3) = arr(i, 3)
brr(m, 4) = arr(i, 4)
brr(m, 1) = arr(i, 1)
End If
If arr(i, 2) = "足金手镯" Then
m = m + 1
brr(m, 2) = arr(i, 2)
brr(m, 3) = arr(i, 3)
brr(m, 4) = arr(i, 4)
brr(m, 1) = arr(i, 1)
End If
If arr(i, 2) = "足金戒指" Then
m = m + 1
brr(m, 2) = arr(i, 2)
brr(m, 3) = arr(i, 3)
brr(m, 4) = arr(i, 4)
brr(m, 1) = arr(i, 1)
End If
If arr(i, 2) = "足金吊坠" Then
m = m + 1
brr(m, 2) = arr(i, 2)
brr(m, 3) = arr(i, 3)
brr(m, 4) = arr(i, 4)
brr(m, 1) = arr(i, 1)
End If
If arr(i, 2) = "足金金条" Then
m = m + 1
brr(m, 2) = arr(i, 2)
brr(m, 3) = arr(i, 3)
brr(m, 4) = arr(i, 4)
brr(m, 1) = arr(i, 1)
End If
If arr(i, 2) = "古法金" Then
m = m + 1
brr(m, 2) = arr(i, 2)
brr(m, 3) = arr(i, 3)
brr(m, 4) = arr(i, 4)
brr(m, 1) = arr(i, 1)
End If
Next
End With
With Worksheets("入库单")
Sheet1.Range("b5:j50").ClearContents
.Range("B5").Resize(UBound(brr), UBound(brr, 2)) = brr
End With
End Sub |