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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif does not work 2
How to hide rows having a specific value in cell of column A ? 0
Copy addition formula of non-consecutive horizontal cells 2
Remove Identical words 0
FORMULA HELP ! ! 1
Help with indirect 5
Formula Question 4
Indirect address 4

Top