第1个回答 2011-11-01
我做一个宏,怎么发给你。
Sub 删除重复数据Macro4()
'
' 删除重复数据Macro4 Macro
'
'
Range("I1").Select
ActiveCell.FormulaR1C1 = "=RC[-8]"
Range("I2").Select
ActiveCell.FormulaR1C1 = _
"=IF(ROW()>COUNTIF(C[-8],""<>""),""数据完毕"",IF(ISERROR(1/COUNTIF(R1C:R[-1]C,RC[-8])),RC[-8],""""))"
Range("H1").Select
ActiveCell.FormulaR1C1 = _
"=IF(ROW()>COUNTIF(C[-7],""<>""),""数据完毕"",IF(RC[1]="""","""",SUMPRODUCT((C[-7]=RC[1])*C[-6])))"
Range("H1").Select
Selection.AutoFill Destination:=Range("H1:H2"), Type:=xlFillDefault
Range("H1:H2").Select
Range("F1").Select
ActiveCell.FormulaR1C1 = "=IF(ROW()>COUNT(C[2]),"""",LARGE(C[2],ROW()))"
Selection.AutoFill Destination:=Range("F1:F2"), Type:=xlFillDefault
Range("F1:F2").Select
Range("E1").Select
ActiveCell.FormulaR1C1 = _
"=IF(ROW()>COUNT(C[3]),"""",VLOOKUP(RC[1],C[3]:C[4],2,FALSE))"
Selection.AutoFill Destination:=Range("E1:E2"), Type:=xlFillDefault
Range("E1:E2").Select
Range("E2:I2").Select
Selection.AutoFill Destination:=Range("E2:I2401"), Type:=xlFillDefault
Range("E2:I2401").Select
Columns("E:F").Select
Range("E2385").Activate
Selection.Copy
Columns("A:A").Select
Range("A2385").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Columns("C:J").Select
Range("C2385").Activate
Application.CutCopyMode = False
Selection.Delete Shift:=xlToLeft
Selection.End(xlUp).Select
End Sub