|
写着玩- Sub copy_new()
- Dim sr As String
- Dim arr
- Dim i, x As Integer
- sr = Sheet2.Range("E1").Value
- Sheet2.Range("D6:L1000").ClearContents
- arr = Sheet1.Range("a6:t" & Sheet1.Range("A10000").End(xlUp).Row - 1).Value
- For i = 1 To UBound(arr)
- If arr(i, 1) = sr Then
- x = Sheet1.Range("a" & i + 5).MergeArea.Count
- Sheet2.Range("d6").Resize(x, 3).Value = Sheet1.Range("a" & i + 5).Offset(, 1).Resize(x, 3).Value
- Sheet2.Range("g6").Resize(x, 1).Value = Sheet1.Range("a" & i + 5).Offset(, 5).Resize(x, 1).Value
- Sheet2.Range("h6").Resize(x, 2).Value = Sheet1.Range("a" & i + 5).Offset(, 13).Resize(x, 2).Value
- Sheet2.Range("k6").Resize(x, 2).Value = Sheet1.Range("a" & i + 5).Offset(, 18).Resize(x, 2).Value
- Sheet2.Range("j6").Value = "=H6*I6"
- Sheet2.Range("j6").Resize(x - 1, 1).FillDown
- Exit For
- End If
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|