|
就是在一组无规律的表中,将列名相同的一列数据复制出来
再在空白地方粘贴
附件为实验数据,不知如何将列名为“累计沉降值㎜”的所有列复制出来
谢谢各位大师的帮助,感激不尽
本帖最后由 sunjing-zxl 于 2011-6-12 13:09 编辑
回复 reisword 的帖子
上面用技巧给你做的,
下面用VBA给你做
- Sub 数据生成()
- Dim Ro As Long, Co As Long, i As Long
- With Sheet1
- Ro = .[A65536].End(xlUp).Row
- For Co = 1 To .[A1].End(xlToRight).Column
- If .Cells(1, Co) = "累计沉降值㎜" Then
- i = i + 1
- .Range(.Cells(1, Co), .Cells(Ro, Co)).Copy Sheet3.Cells(1, i)
- End If
- Next Co
- End With
- End Sub
- Sub 清楚数据()
- Dim Ro As Long
- Dim Co As Long
- With Sheet3
- Co = .[A1].End(xlToRight).Column
- Ro = .[A1].End(xlDown).Row
- .Range(.Cells(1, 1), .Cells(Ro, Co)).ClearContents
- End With
- End Sub
复制代码附件:
实验数据.rar
(16.62 KB, 下载次数: 43)
|
|