Is this possible? comparing two sheets

[mcintoshmc]

Sheet 1 is a roster of all employees. I added a new column (T) at the end of the roster and put the date the roster was run.
Sheet 2 is the exact same as sheet 1, but it will be a new roster.

For example, sheet 1 will contain 4/18 and sheet 2 will contain 4/19 in column T.

Column A is the identifier. I would like to create a third sheet, that will identify the Unique values between both sheets from Column A, and provide the corresponding date from column T.

So, new hire employee ID from column A will show "12345" with a date of 4/19 from column T. Is this possible?

 

[mcintoshmc]

guess it's not possible 8-(

 

[Fluff]

How about

Sub IdUnique()

   Dim Cl As Range
   Dim ws1 As Worksheet
   Dim ws2 As Worksheet
   
   Set ws1 = Sheets("Pcode")
   Set ws2 = Sheets("Sheet2")
   
   With CreateObject("scripting.dictionary")
      For Each Cl In ws1.Range("A2", ws1.Range("A" & Rows.Count).End(xlUp))
         If Not .exists(Cl.Value) Then .Add Cl.Value, Cl.Offset(, 19).Value
      Next Cl
       For Each Cl In ws2.Range("A2", ws2.Range("A" & Rows.Count).End(xlUp))
         If Not .exists(Cl.Value) Then
            .Add Cl.Value, Cl.Offset(, 19).Value
         Else
            .Remove Cl.Value
         End If
      Next Cl
      Sheets("Sheet3").Range("A1").Resize(.Count).Value = Application.Transpose(.keys)
      Sheets("Sheet3").Range("B1").Resize(.Count).Value = Application.Transpose(.items)
   End With
End Sub