If you apply autofilter to that column and select "cash" from the
filter pull-down, you will see only those records. Then highlight the
visible records and copy/paste them to the new sheet - only the
filtered records will be copied.

Hope this helps.

Pete

On Sep 24, 2:18*am, GA85 wrote:
I need a formula to do the following:

If in column 3, a cell says "cash", I need that entire row that contains
"cash" in column 3 to be transferred to another worksheet.

PLEASE HELP!!