FORMULA HELP ! ! !

G

GA85

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

Sheeloo

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... :)
 
Top