|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 24th, 2008, 02:18 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
September 24th, 2008, 09:57 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA HELP ! !
If you apply autofilter to that column and select "cash" from the
filter pull-down, you will see only those records. Then highlight the visible records and copy/paste them to the new sheet - only the filtered records will be copied. Hope this helps. Pete On Sep 24, 2:18*am, 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!!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
