| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to cut rows into another worksheet if a cell contains a specific word
Ive got a spreadsheet which contains outstanding share trades which clients
have placed, but it contains other products i do not deal with. I would like the macro to run throught the asset name column and to cut the entire row into another worksheet called delete if it contains either of the following: SWAPS, FX, CFD,Bank Bill,pension or SUPER. Would this code be straight forward to write? anyone with suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Hiding rows if specific cell does not contain key word | Excel Worksheet Functions | |||
| Open a specific Word document from an Excel Macro | Excel Programming | |||
| delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
| Macro to search a column for a specific word and replace with | Excel Programming | |||
Threaded Mode
