I have a large spreadsheet with many, may worksheets in it. I've been asked to find a way to search for a particular text item in one column, and then, once it's found, to copy the row to a brand new worksheet. So...in other words...if in column B, we find the word "WHITE", the rest of the row information in that row is copied to a brand new spreadsheet.

Someone is trying to cull any records that contain a specific word to a new worksheet.

We're using Excel 2010.

I'm not an Excel expert, so I'm hoping someone may be able to help!

Many thanks!

Pat