|
把下面的代码放在表“汇总”里:
s = ""
For i = 2 To Worksheets("数据").[a10000].End(3).Row
s = IIf(Len(s) = 0, Worksheets("数据").Cells(i, 1) & "、" & Worksheets("数据").Cells(i, 2), s & Chr(10) & Chr(13) & Worksheets("数据").Cells(i, 1) & "、" & Worksheets("数据").Cells(i, 2))
Next i
Cells(1, 1) = s
|
|