VBA Code for filtering for the same value in three different columns

[danweir]

This has been asked multiple times but I am not getting it. Is there a way to use a filter on the following table so rows 1,2,3,5,8,10 (not counting the header row) are shown when "ne" is the criteria?

first	last	area1	area2	area3
alice	smith	ne
tom	brown	mw	ne
dan	white	se		ne
nancy	black	south
mary	jones	north	ne
shauna	yang	mw
dave	young	west
harry	harrison	ne
ann	lee	south
don	long	mw		ne

<tbody>
</tbody>

I would then use the result to create a workbook of all the agents that have anything to do with the ne area.

I hope that makes sense.

Thanks.................Dan

 

[Andrew Poulsom]

To do that you would need to use Advanced Filter with OR criteria:

Excel Advanced Filter Introduction