| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA HELP ! ! !
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA 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... :-) "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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
