Extract records based on criteria

Hi All,


I have a list containing numerous records. There are many fields, One of the field in the record is "CODE" there are different codes in this field, all i want to do is fetch only specific field of the record pertaining to CODE = 105, 106 and 109, on a separate sheet, i want to have a macro so that i can fetch the records, it should search all the code one by one until the Code list ends.


Thanks in advance