|
Sub 复制数据()
Dim sht, irow&
Application.ScreenUpdating = False
Worksheets(1).Activate
irow = Cells(Rows.Count, 1).End(xlUp).Row
If irow > 1 Then irow = irow + 1
For Each sht In Worksheets
If sht.Name <> Worksheets(1).Name Then
With sht
.Range("a8:a8").Copy Range("a" & irow)
irow = Cells(Rows.Count, 1).End(xlUp).Row + 1
.Range("d6:d6").Copy Range("b" & irow)
irow = Cells(Rows.Count, 1).End(xlUp).Row + 1
.Range("e6:e6").Copy Range("c" & irow)
irow = Cells(Rows.Count, 1).End(xlUp).Row + 1
End With
End If
Next
Application.ScreenUpdating = True
End Sub
- Private Sub CommandButton1_Click()
- Dim sht, irow&
- Application.ScreenUpdating = False
- Worksheets(1).Activate
- irow = Worksheets(1).Cells(Rows.Count, 1).End(xlUp).Row
- If irow > 1 Then irow = irow + 1
- For Each sht In Worksheets
- If sht.Name <> Worksheets(1).Name Then
- With sht
- irow = irow + 1
- .Range("a8:a8").Copy Range("a" & irow)
- .Range("d6:d6").Copy Range("b" & irow)
- .Range("e6:e6").Copy Range("c" & irow)
- End With
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|