Macro to find value and hide other rows

Hello,

I hope someone can help me.

I've got a set of data that contains many records for my company.

I want to be able to specify a certain value then run a macro that will filter my data by hiding the other rows that didn't contain my data

For example:-

I've got four columns called ID, Michael, Peter and David. ID is unique where as the data in the other columns might be repeated.

ID Michael Peter David
1 316 4324 213
2 212 213 321
3 235 332 316
4 675 956 542
5 456 234 235


Say I wanted to search for the no 316. I want run the macro which will hide Rows 2, 4 and 5 because it doesn't contain 316.

I'm using Microsoft Excel 2007

Thanks

Michael