So with everybodys help on here and a lot of research I have a macro that copies and pastes numbers from one sheet to another and then if there are any duplicates it removes them. It also looks through the numbers that are already on the second sheet and if the are not on the first sheet it dates a cell. Now this is pretty much what I need except one step further, when the number is brought to the second sheet I need it to date a cell two cells over. I have to following code already
Sub Udpate()
'
' Update Macro
' Keyboard Shortcut: Ctrl Shift + U
'
Dim lst As Long
Sheets("Input").Range("B2:C51").Copy
With Sheets("Sheet1")
lst = .Range("A" & Rows.Count).End(xlUp).Row + 1
.Range("A" & lst).PasteSpecial xlPasteValues
End With
Dim x As Long
Dim LastRow As Long
LastRow = Range("B65536").End(xlUp).Row
For x = LastRow To 1 Step -1
If Application.WorksheetFunction.CountIf(Range("A2:A" & x), Range("A" & x).Text) > 1 Then
Range("A" & x).EntireRow.Delete
End If
Next x
Dim ws1 As Worksheet: Set ws1 = Sheets("Sheet1")
Dim ws2 As Worksheet: Set ws2 = Sheets("Input")
Dim Range1 As Range, Range2 As Range, icell As Range, iFind As Range
Set Range1 = ws1.Range("A2:A" & ws1.Range("A" & Rows.Count).End(xlUp).Row)
Set Range2 = ws2.Range("B2:B" & ws2.Range("B" & Rows.Count).End(xlUp).Row)
For Each icell In Range1
If IsNumeric(icell.Value) Then
Set iFind = Range2.Find(What:=icell.Value, LookIn:=xlValues, lookat:=xlWhole)
If iFind Is Nothing Then
icell.Offset(0, 3).Value = Date
End If
End If
Next icell
End Sub
I would imagine it is just adding another line to the top function but I can not figure it out
Bookmarks