Filter Excel Data using vba multiple criteria

pmyk

New member
Joined
Oct 15, 2013
Messages
14
Reaction score
0
Points
0
Filter Excel Data using vba multiple criteria
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
 
Top