Copying Row With Prevent Duplicate Entries

I've got this code for prevent duplicate entries, But I wondering if it's possible to add a copy rows to it? For Example

Columns C
ItemID ItemName
11 QWE
22 ASD
33 ZXC

So now I enter 22 in ItemID for this working code it will pop up a MsgBox saying Aready exist, Is it possible to add a code so that it will copy the existing copy and paste into the active row?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Dim ans As String
Const myCol As Long = 3
If Intersect(Target, Columns(myCol)) Is Nothing Then Exit Sub
Application.EnableEvents = False.........