View Single Post
 
Old 09-07-2014, 10:24 PM
jolivanes jolivanes is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default

Or with code.
Code:
Sub Maybe()
    Dim vMatch As Variant, lngRow As Long, lr As Long
    Application.ScreenUpdating = False
    lr = Cells(Rows.Count, 1).End(xlUp).Row
    For lngRow = lr To 2 Step -1
        vMatch = Application.Match(Cells(lngRow, "A"), Cells(1, "A").Resize(lngRow - 1), 0)
        If IsNumeric(vMatch) Then Cells(lngRow, "A").EntireRow.Hidden = True
    Next lngRow
    Range("A2:A" & lr).Resize(, 2).SpecialCells(12).Copy Sheets("Sheet3").Range("A1") '<---Copies from Col A & B only
    Range("A2:A" & lr).EntireRow.Hidden = False
    Application.ScreenUpdating = True
End Sub
Reply With Quote