improve loop

The best way to improve your loop is to get rid of it.

In Pseudocode:

Copy all your data to sheet2

Insert a formula in an Empty column to to return a 1 if column A <> Name

Copy Paste Values

Use select Special to select all the 1's in our helper column.

Resize the selection to Delete all your flagged Rows

There is no loop so this should be fast.

Please Login or Register  to view this content.

Or test such code:

Please Login or Register  to view this content.

EDIT: I have added a sample of attachment of what I am attempting to accomplish

hello kaper- I am testing your suggested code. It is not looping to the next record in this section:

Please Login or Register  to view this content.

have you seen the yellow banner at the top of the page? Please follow the advice

According to post #4 attachment a VBA beginner starter demonstration :

PHP Code: 

Sub Demo1()
    Sheet2.UsedRange.Columns(1).Copy Sheet2.[K1]
    Sheet1.[C1:D1].Copy Sheet2.[C1]
    Sheet1.UsedRange.AdvancedFilter xlFilterCopy, Sheet2.[K1].CurrentRegion, Sheet2.[A1:D1]
    Sheet2.[K1].CurrentRegion.Clear
End Sub 


The same demonstration revamped :

PHP Code: 

Sub Demo1r()
    With Sheet2.UsedRange.Columns
        .Item(1).Copy .Item(11)
         Sheet1.[C1:D1].Copy .Range("C1")
         Sheet1.UsedRange.AdvancedFilter xlFilterCopy, .Item(11), .Range("A1:D1")
        .Item(11).Clear
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

The example you posted in post #4 is quite different than what has been posted in post #1
Moreover, I suspect that example data is oversimplified (see below for the attachment suggestions), because for such data with unique ID, a simple VLOOKUP would do the job.
Use in C2 in sheet 2:

Formula:

Please Login or Register  to view this content.

and the same in D2, but with 4 (instead of 3) as third argument.

---
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If there are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, empty cells between data, mixed text/numbers, etc. - please show them all, or at least indicate in text). The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

This works when the keys are properly entered - In your sample there were 3 East 95's for instance.

But try it and see whether it works for you:

Please Login or Register  to view this content.