| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find word initial then final......
Can someone please help with this small request.
I need a macro to find the word "intial" in column A and if the word in the cell immediately below that contains the word "final" then it should delete both the two rows. The have to be in the order of "Intial" then "Final" as this would mean there has been no activity in between the two. I hope someone can help. Thanks in advance, Andrea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows. | Excel Programming | |||
| Macro to find a word and copy all rows with this word to diff ws | Excel Programming | |||
| macro to intsert a word using the "Find" command to search for a word | Excel Programming | |||
| Format fonts (ie, initial cap) in Excel like you can in Word. | Excel Discussion (Misc queries) | |||
| Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
![amorrison2006@googlemail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
