也可这样
Sub TEST()
With Sheets("汇总表")
D = .Rows("1:1").Find(Range("J1").Value, LookIn:=xlValues).Address
Set R = .Range(Split(Split(D, "$")(1))(0) & 2)
If Range("L1") = "A" Then F = 0 Else F = 1
For I = 7 To 23
R.Offset(I - 6, F) = Cells(I, "AD")
Next
For I = 26 To 42
R.Offset(I - 5, F) = Cells(I, "AD")
Next
End With
MsgBox "上传成功,可以保存报表"
Range("AC4") = True
End Sub