Conditional copying of Excel worksheet rows to a new worksheet based on specific field content

I want to conditionally copy Excel worksheet rows based on a specific field content of the row to be copied to a different worksheet. The source worksheet is large and some of the fields of the row to be copied have large text data content.