Sub 按钮2_Click() Dim i, k, l, m, x, y, rng l = [iv1].End(xlToLeft).Column m = Sheet2.Cells.SpecialCells(xlCellTypeLastCell).Row For i = 1 To l rng = Sheet2.Range("1:1").Find(Cells(1, i), LookIn:=xlValues).Column If rng <> "" Then Cells(2, i).Resize(m - 1, 1) = Sheet2.Cells(2, rng).Resize(m - 1, 1).Value End If Next End Sub
44这个 |