FORMULA HELP ! ! !

  • Thread starter Thread starter GA85
  • Start date Start date
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!!
 
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... :-)
 
Back
Top