|
发一段很“笨”的程序,但保证你的数据正确。觉得好用送花鼓励,新人还需要大家照应。
- Sub 填汇总表()
- Dim H_max_row, S_max_row, i, j, r As Integer
- Dim arr
- H_max_row = Sheets("汇总").Range("b65536").End(xlUp).Row
- S_max_row = Sheets("社保账户").Range("b65536").End(xlUp).Row
-
- ReDim arr(1 To S_max_row) As Byte '标志
- '查找并填写相同账号的数据
- For i = 3 To (S_max_row)
- For j = 3 To (H_max_row)
- If Sheets("汇总").Cells(j, 2) = Sheets("社保账户").Cells(i, 2) Then
- Sheets("汇总").Cells(j, 4) = Sheets("社保账户").Cells(i, 3)
- arr(i) = 1
- Exit For
- End If
- Next j
- Next i
- '在汇总表尾部追加不同账号的数据
- r = H_max_row
- For i = 3 To (S_max_row)
- If arr(i) <> 1 Then
- r = r + 1
- Sheets("汇总").Cells(r, 4) = Sheets("社保账户").Cells(i, 3)
- Sheets("汇总").Cells(r, 3) = Sheets("社保账户").Cells(i, 1)
- Sheets("汇总").Cells(r, 2) = Sheets("社保账户").Cells(i, 2)
- End If
-
- Next i
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|