|
楼主 |
发表于 2012-10-16 13:08
|
显示全部楼层
本帖最后由 qjsu 于 2012-10-16 13:10 编辑
lisachen 发表于 2012-10-16 11:26
此文件稍作了修改
就是这个意思,这就是我想要的,另外分组代码能从小到大排序吗?能把重复的区域合并不?
我修改了一下代码,适合我的程序,能在我的代码基础上修改吗?
Sub test()
Dim arr, brr(1 To 10000, 1 To 2)
arr = Sheets("sheet2").Range("b2:b54")
With Sheets("sheet3")
For x = 1 To UBound(arr)
For Each rg In .Range("a1:jo100")
If rg.Value = arr(x, 1) Then
brr(x, 1) = brr(x, 1) & .Cells(1, rg.Column - 1) & ","
brr(x, 2) = brr(x, 2) & .Cells(1, rg.Column) & ","
End If
Next rg
Next x
End With
Sheets("sheet2").Range("f2").Resize(UBound(arr), 2) = brr
End Sub |
|