|
Private Sub CommandButton1_Click()
Dim zhs, k1, ls
zhs = Sheet1.[B65536].End(xlUp).Row
ls = Sheet1.Range("iv1").End(xlToLeft).Column
Sheet2.Columns(1).Value = Sheet1.Columns(1).Value
For k1 = 1 To ls - 2
Sheet2.Range(Sheet2.Cells(1, k1 * 2), Sheet2.Cells(zhs, k1 * 2)).Value = Sheet1.Range(Sheet1.Cells(1, 2), Sheet1.Cells(zhs, 2)).Value
Sheet2.Range(Sheet2.Cells(1, k1 * 2 + 1), Sheet2.Cells(zhs, k1 * 2 + 1)).Value = Sheet1.Range(Sheet1.Cells(1, 2 + k1), Sheet1.Cells(zhs, 2 + k1)).Value
Sheet2.Range(Sheet2.Cells(1, k1 * 2), Sheet2.Cells(zhs, k1 * 2 + 1)).Sort Key1:=Sheet2.Cells(1, k1 * 2 + 1), Order1:=xlDescending, Header:=xlGuess, OrderCustom:=1
Next k1
Sheet2.Activate
End Sub |
评分
-
1
查看全部评分
-
|