VBA function to filter across multiple columns

[milkychips]

A2:D8

I would like to have a piece of code that helps me to only display rows that contain the value in cell E1.

	Column A	B	C	D
Row2	Cat	1	Mouse	2
Row3	Dog	3	Horse	7
Row4	Squirrel	8	Cat	4
Row5	Bat	3	Chicken	8
Row6	Dog	2	Squirrel	0
Row7	Duck	1	Horse	4
Row8	Cat	6	Koala	3

So if E1 contained the word "Cat"
only the following rows would appear

	Column A	B	C	D
Row2	Cat	1	Mouse	2
Row4	Squirrel	8	Cat	4
Row8	Cat	6	Koala	3

 

[sericom]

Do you want to hide or deleted the rows that don't contain the value in E1, or copy the matches to another location?
Also, is column A and C the only columns to check?

 

[milkychips]

I only want to hide the rows.
Yes, A and C are the only columns to check