Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to search a worksheet for "apple". When it finds "apple", I
want it to select that row, as well as the row below it (which does not contain the word "apple".) I would like to continue to search until the end of the worksheet. So, it will find all rows that contain the word "apple", select that row, as well as the row directly beneath it. Then it needs to cut these cells and paste into a new worksheet. The rows will never be the same, but the word "apple" will always occur in column A. "apple" will never be the first or last word in the cell. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing cell format based on word in first cell of row | Excel Programming | |||
Find part of a word in cell | Excel Discussion (Misc queries) | |||
How do I find out if a cell has my word in it? | Excel Programming | |||
Find last word in cell | Excel Programming | |||
find word in a cell then change cell format | Excel Programming |