Compare two columns text [Closed]

Question

Compare two columns text [Closed]

Report

Zak - Jun 28, 2012 at 03:13 AM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- Jun 28, 2012 at 06:55 AM

Hello,

If the text of any cell in column-A matches with the text of any cell in column-B, copy entire row to next sheet.

Like

Column-A Column-B
Private Car
Private Motorcycle
Private Car
Private Motorcycle
Private Car
Private Motorcycle
Private Bus
Private Bus

copy entire rows of Private Cars to next sheet

Private Car
Private Car
Private Car

kindly provide me the Macro coding solution for above

Regards

Zak

Compare two columns text
Compare two columns in excel for partial matches - How-To - Excel
Excel macro to compare two columns and write to a third ✓ - Forum - Excel
How To Compare Two Columns in Excel - How-To - Excel
Excel - Comparing 2 columns and removing duplicates - How-To - Excel
Excel - Comparing two columns - How-To - Excel

1 reply

Ask a question

venkat1926 · Answer 1 · 2012-06-28T06:55:43-0400

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
Jun 28, 2012 at 06:55 AM

Sub test()
Dim r As Range, filt As Range
Worksheets("sheet2").Cells.Clear
With Worksheets("sheet1")
Set r = .Range("a1").CurrentRegion
r.AutoFilter field:=1, Criteria1:="private"
r.AutoFilter field:=2, Criteria1:="car"
Set filt = r.Offset(1, 0).Resize(r.Rows.Count - 1).SpecialCells(12)
filt.Copy
With Worksheets("sheet2")
.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
End With
.AutoFilterMode = False
End With
Application.CutCopyMode = False
End Sub

Compare two columns text [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!