remove duplicates
 

hi all

i have in raw A phone list in raw B we have customer that ask to be removed
from call list
what can i do to have clean list in raw C

remove duplicates
 

If you delete those records, they are gone forever. Maybe you just want to
hide them. Put the word 'Hide' in Column C, in the rows of clients that are
not supposed to be called, and run this:
Sub HideRows()
Dim b As Boolean

Set r = ActiveSheet.UsedRange
nLastRow = r.Rows.Count + r.Row - 1

For rr = 1 To nLastRow
b = False
For cl = 3 To Columns.Count
If Cells(rr, cl).Text = "Hide" Then
b = True
End If
Next
If b Then
Cells(rr, 1).EntireRow.Hidden = True
End If
Next
End Sub



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"asol" wrote:

hi all

i have in raw A phone list in raw B we have customer that ask to be removed
from call list
what can i do to have clean list in raw C