'Need a vba that can search in one column for certain words

Need a vba that can search in one column for certain words and when found copy them to another column. For example, if the word t-shirt exists, it is copied over or if a sweater is found, it is copied over.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source