M
mrsviqt
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.
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.