Sub text()
Dim st As Worksheet
Worksheets.Add after:=Sheets(Sheets.Count)
Sheet1.Range("1:1").Copy Sheets(5).Range("a1")
For Each st In Worksheets
If st.Name <> Sheets(5).Name Then
st.Range(st.Cells(2, 1), st.Cells(2, 1).End(xlToRight).End(xlDown)).Copy _
Sheets(5).Range("a" & Sheets(5).Cells(Rows.Count, 1).End(3).Row + 1)
End If
Next
End Sub
Sub text()
Dim st As Worksheet
Worksheets.Add after:=Sheets(Sheets.Count)
Sheet1.Range("1:1").Copy Sheets(5).Range("a1")
For Each st In Worksheets
If st.Name <> Sheets(5).Name And st.Name <> Sheet2.Name Then
st.Range(st.Cells(2, 1), st.Cells(2, 1).End(xlToRight).End(xlDown)).Copy _
Sheets(5).Range("a" & Sheets(5).Cells(Rows.Count, 1).End(3).Row + 1)
End If
Next
End Sub
谢谢啦
我现在想把sheet1和sheet3中的数据复制到sheet4中,代码如下Sub text()
Dim st As Worksheet
Worksheets.Add after:=Sheets(Sheets.Count)
Sheet1.Range("1:1").Copy Sheets(4).Range("a1")
For Each st In Worksheets
If st.Name <> Sheets(4).Name And st.Name <> Sheet2.Name Then
st.Range(st.Cells(2, 1), st.Cells(2, 1).End(xlToRight).End(xlDown)).Copy _
Sheets(4).Range("a" & Sheets(4).Cells(Rows.Count, 1).End(3).Row + 1)
End If
Next
End Sub