Not entirely sure I know what you want to achieve.
Let's say sheet1
Column A = Description
Column B = Price
Column C = Code number
The following code copies Column A:C to the first available row in Sheet2 when the code number is entered:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("C:C")) Is Nothing Then Exit Sub
Range("A" & Target.Row, "C" & Target.Row).Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
You want to retrieve the description and price from Sheet1 when you enter the code number in Sheet2. To do that use VLOOKUP.
Let me know if further assistance is desired.