Macro to find value and hide other rows

Closed
316hitmanhart - Oct 17, 2010 at 10:42 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 17, 2010 at 01:09 PM
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



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 17, 2010 at 01:09 PM
will not simple filter work here ?
-1