Copy row to another sheet based on yellow highlighting.

[imogul]

I'm pulling my hair out cause I figured this out last year and now I can't find it.

I am given this spread sheet monthly that has conditional formatting applied already. Column B has various notes, and the ones with the word "faculty" are highlighted by conditional formatting.

I need to copy the rows, where cell B is highlighted yellow, into sheet 2. Any help would be appreciated!

 

[JoeMo]

If the colored cells always contain the word "faculty" you can apply a filter to the column B entries and use contains "faculty" to show only the records you want to copy. Then copy all such records and paste into sheet2.