Help Need VBA Code to copy rows to a new worksheet based on criteria

[goodeman]

This may have been posted already but I could not find anything that fit my wish.

I need a macro that will search data from a range of cells in one column for multiple criterias and them copy the entire rows to a new worksheet.

Example I have a list of group names

Network
Telcom
Help Desk
BA
Network

I only want to choose all Network and Telcom rows copy to another worksheet.

 

[philobr]

Hi Jon,
thanks for the help on this.