|
本帖最后由 327718098 于 2017-5-20 16:54 编辑
Sub text()
Application.ScreenUpdating = False
Dim st As Worksheet, rng As Range
For Each st In Worksheets
If st.Name <> Sheet1.Name And st.Name <> Sheet2.Name Then
For Each rng In st.Range(st.Range("a:a").Find("产品组成").Offset(1, 1), st.Range("A:A").Find("产品组成").Offset(1, 1).End(xlDown))
hh = Sheet1.Cells(Rows.Count, 1).End(3).Row + 1
Sheet1.Cells(hh, 1) = st.[b2]
Sheet1.Cells(hh, 2) = st.[d2]
Sheet1.Cells(hh, 3) = IIf(rng.Offset(0, -1) = "", rng.Offset(0, -1).End(xlUp).Value, rng.Offset(0, -1))
Sheet1.Cells(hh, 4) = rng
rng.Offset(0, 1).Resize(1, 23).Copy Sheet1.Cells(hh, 5)
Next
End If
Next
Application.ScreenUpdating = True
End Sub
|
|