Compare Macro in Excel
Closed
Smitty
-
10 Dec 2010 à 17:55
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 11 Dec 2010 à 05:55
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 11 Dec 2010 à 05:55
Related:
- Compare Macro in Excel
- Beyond compare - Download - File management
- How to merge and compare two excel files - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel online macros - Guide
- Arrow keys not working in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
11 Dec 2010 à 05:55
11 Dec 2010 à 05:55
supposse the data is similar to the follwing from A1 down and in column B(NO header row)
a a
s d
d g
f
g
h
now try this macro
a a
s d
d g
f
g
h
now try this macro
Sub test()
Dim r As Range, c As Range, cfind As Range, dest As Range, x As String
Columns("D:D").Delete
Set r = Range("A1").CurrentRegion
For Each c In r
If WorksheetFunction.CountIf(r, c.Value) = 1 Then
c.Copy
Set dest = Cells(Rows.Count, "D").End(xlUp).Offset(1, 0)
dest.PasteSpecial
End If
Next c
End Sub
