how to make quick filtering rows macro?

Hello,

I have a sheet with huge list of goods. I want to filter these lists by input value. First column has part code, second column has part name, third column has part description, etc.

I want it to work like this: if I write the code for the part in top cell, I want excel to leave only the rows with the code, containing the code I am entering. See the picture below. Could you please help me find the information how should I do this?

This is a full sheet:
http://s28.postimg.org/lusr2px7h/full.jpg


This what happens if I write the name "grease" in the top filtering cell: it filters and shows only the rows, which has the name "grease" in the part name:

http://s3.postimg.org/xz5kel8ib/grease.jpg

This file is provided for me from the supplier, but the VBA code is password protected. It is a nice system and I want it to make similar usage of my own for different purpose, and I want to know how can I achieve it.

Thank you for your help