I am trying to return the text in column d and e onto a seperate worksheet if column a cell in column a has the word "stop" in it. column a can have the word stop many times on different rows so the fisrt time it finds it (as an example in A4 it should return what is in cell D4 and E4 cells F7 and G7 in the other worksheet. Then if it finds the word stop in cell A9 it should return what is in D9 and E9 to F8 and G8. Hope this makes sense I am frazzled trying to figure this out. Thanks
Bookmarks