|
楼主 |
发表于 2018-4-5 21:45
|
显示全部楼层
- Sub 提取() '提取其他工作表数据
- Dim Temp As String
- Temp = "'" & ThisWorkbook.Path & "\[abc.xls]Sheet1'!"
- With Sheet1.Range("A2:Q1000") '取abc.xls工作簿Sheet1工作表("A1:C1")单元格数据,A1--C1为范围(根据需要更改)
- .FormulaR1C1 = "=" & Temp & "RC"
- .Range("A2:R2") = .Value ' 数据放到本工作簿Sheet1("A2:C2") 中,A1--C1为范围(根据需要更改)
- End With
- End Sub
- '问题:需要用“Q10000”解决范围选取。要改进循环判断语句,否则提取后为0,删除重复行时,很费时间
- '问题:提取的第2行,改变了格式
复制代码- Sub 删除重复行()
- Dim m%, k%
- For m = Range("a65536").End(xlUp).Row To 2 Step -1
- For k = m - 1 To 2 Step -1
- If Cells(m, "b") = Cells(k, "b") And _
- Cells(m, "c") = Cells(k, "c") And _
- Cells(m, "d") = Cells(k, "d") And _
- Cells(m, "e") = Cells(k, "e") And _
- Cells(m, "f") = Cells(k, "f") And _
- Cells(m, "g") = Cells(k, "g") And _
- Cells(m, "h") = Cells(k, "h") And _
- Cells(m, "j") = Cells(k, "j") And _
- Cells(m, "k") = Cells(k, "k") And _
- Cells(m, "l") = Cells(k, "l") And _
- Cells(m, "m") = Cells(k, "m") And _
- Cells(m, "n") = Cells(k, "n") And _
- Cells(m, "o") = Cells(k, "o") Then
- Cells(m, "a").EntireRow.Delete Shift:=xlUp '上面语法表示--对比列(b列--o列)
- End If
- Next
- Next
- End Sub
- '问题:数据多时,运行速度很慢,很费时间,求优化
复制代码
|
|