Find rows that contain one of 6 variations of specific character string and paste those rows into another worksheet
Posted on 2014-09-15
Sheet 1 contains 54,000 rows of text and/or numbers. I am looking for a macro that will find those rows that contain any of the variations of the 6 RCO strings outlined below and copy those rows that meet this criteria into Sheet 2. The RCO string could be located anywhere within the row.
Variations of RCO string: