Is it a one time activity? If yes, then filter on Col 3 on Cash, select
VISIBLE cells only and paste in the new worksheet...

If it is to be repeated then RECORD a macro while doing the above and rerun
it whenever you want... :-)

"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!!