i have a list of words in colA of sheet1. i want a macro to copy every row that have the string "red" and paste it to colA in sheet2. ColA can have more than 1 word per cell
i have a list of words in colA of sheet1. i want a macro to copy every row that have the string "red" and paste it to colA in sheet2. ColA can have more than 1 word per cell