第2个问题,用这个宏
假设你只有5行数据,你可以根据你的实际行数,修改 To 后面的数字。
Sub test2()
Dim i As Integer
Dim A As Integer
i = 1
A = 0
For i = 1 To 5
If Worksheets("Sheet2").Cells(i, 1).Value = Worksheets("Sheet1").Cells(2, 1).Value Then
A = A + Worksheets("Sheet2").Cells(i, 2).Value
Worksheets("Sheet1").Cells(2, 2).Value = A
Else
Worksheets("Sheet1").Cells(i, 2).Value = ""
End If
Next i
End Sub
假设你只有5行数据,你可以根据你的实际行数,修改 To 后面的数字。
Sub test2()
Dim i As Integer
Dim A As Integer
i = 1
A = 0
For i = 1 To 5
If Worksheets("Sheet2").Cells(i, 1).Value = Worksheets("Sheet1").Cells(2, 1).Value Then
A = A + Worksheets("Sheet2").Cells(i, 2).Value
Worksheets("Sheet1").Cells(2, 2).Value = A
Else
Worksheets("Sheet1").Cells(i, 2).Value = ""
End If
Next i
End Sub
第一个问题,用下面的宏实现。
Sub test()
Dim i As Integer
i = 1
For i = 1 To 5
If Worksheets("Sheet2").Cells(i, 1).Value = Worksheets("Sheet1").Cells(2, 1).Value Then
Worksheets("Sheet1").Cells(i, 2).Value = Worksheets("Sheet2").Cells(i, 2).Value
Else
Worksheets("Sheet1").Cells(i, 2).Value = ""