|
寻找sheet2的行中出现 1的最早列,将1所在单元格前一单元的日期添加到sheet4.
请教老师.
Sub 拍鸟清单网改11()
Dim x As Long, i As Long, j As Long, k As Long
i = Sheet2.Range("g65536").End(xlUp).Row
j = 0
k = 4
m = 0
For x = 4 To i
If Trim(Sheet2.Cells(x, "ad")) = 1 Then
j = j + 1
y = Application.WorksheetFunction.Match(1, Rows(x), 0)
Sheet4.Cells(j + 1, k + 3) = Sheet2.Cells(x, y - 1)
If j Mod 37 = 36 And j <> 0 Then
k = k + 4
'm = m + 2
j = 0
End If
End If
Next x
MsgBox "执行完毕!"
End Sub
For x = 1 To 1
y = Application.WorksheetFunction.match(1, Sheet2.Range( Sheet2.Cells(x, 3), Sheet2.Cells(x, 26)), 0)
Next
Sheet2.Cells(x, 3) 代表 x 行 C 列
Sheet2.Cells(x, 26) 代表 x 行 Z 列
祝順心,南無阿彌陀佛!
|
|