I have a sheet containing data as following:

Date Code Product Transaction on Qty
21/2 12 Ink Purchase 20/2 30
28/2 11 Ballpen Sales 27/2 25
2/3 12 Ink Sales 1/3 20
5/3 11 Ballpen Return 4/3 12
6/3 11 Ballpen Sales 5/3 9
13/3 12 Ink Sales 11/3 10

I then wish to have a result in other sheet as following :

When the code 12 is entered :

Code : 12
Product: Ink

21/2 Purchase 20/2 30
2/3 Sales 1/3 20
13/3 Sales 11/3 10

when the code 11 is entered, the results relating to Ballpen is listed.

How to set ? I wish to have the table list in the other sheet and not using
filter in the same data sheet.