Filter Excel Data using vba Multiple Columns Multiple Criteria

[pmich]

How to filter records having
Name: Ben.
Address data in any of the 3
columns :
either "School" or "College" or "Office"
within zipcode : 254365.
After using this filter, data of all the three matching IDs i.e.,
1111, 1112, 1114 should be displayed in the filter and ID 1113 should be omitted.
Please help. Thanks in advance.

ColA ColB ColC ColD ColE ColF
1111 - Ben - H.O.D. - Dept of Physics - New College - 254365
1112 - Benny - Manager - Corporate Office - Mount Road - 254365
1113 - Benson - Benson Industry - Sector-G - Industrial Estate - 254365
1114 - Benjamin - Grand School - Cross Road - Old Town - 254365

 

[pmich]

cross posted here: [URL]http://www.excelguru.ca/forums...a-using-vba-multiple-criteria&p=9839#post9839[/url]
Cross posted http://<a href="http://www.vbaexpres...post299242</a>

 

[pmich]

Cross posted here .
This is SOLVED. Thanks everyone on the forum.