Excell Macro Help

Hello,

I am wanting to create an excell macro - that filters out the names in 1 column of the spread sheet - I pull a report everyday that gives the list of work for the day. It pulls the entire region and I only want my city. Technichian is a field it pulls - SO I want to elliminate all the technichians that are not in my area.

I try to use the custom filter option manually but it only allows me to choose 2 names and I need 10 or so.