How to copy cells if column contains specific value/text …

Source: www.extendoffice.com