![]() |
|
#5
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to create specific number of table rows
|
flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
Find specific rows then copy and paste to new doc
|
konopca | Word VBA | 5 | 02-20-2014 02:34 PM |
Deleting rows with specific criteria
|
joflow21 | Excel | 9 | 11-22-2013 12:10 PM |
| Adding columns in specific rows only | mhays | Excel | 5 | 01-17-2012 09:13 AM |
Need help extracting specific text from one doument to another with macro/VBA.
|
zsmithku | Word | 1 | 04-15-2011 03:46 PM |