没有加密喔,代码如下:
Sub demo()
a = [a1].CurrentRegion
For i = 3 To UBound(a)
sh = Array(a(i, 3), a(i, 6)): v = Array(a(i, 6), a(i, 3))
For j = 0 To 1
Set Rng = Sheets(sh(j)).[a:g].Find(v(j), , , , , xlPrevious)
Rng.EntireRow.Insert
With Rng.Offset(-1)
.Offset(, 3).NumberFormat = "@"
.Resize(, 10) = Application.Index(a, i)
.Cells = "=N(R[-1]C)+1"
.Resize(, 7).Borders.LineStyle = xlContinuous
End With
Next
Next
End Sub