Find Multiple Instances of Word in Range and Copy All

I have the below code which I want to find each instance of "Try" in column B and each time it finds it down as far as B300 then if 2 rows to the right of where it is found equals what's in cell C1, copy the cell one the left of where the "Try" was found and paste it into Sheet3 column AL and the last used row.

My code below finds the first instance of the word "Try" and copies and pastes correctly but how can I loop it so that it searches through the entire range B2:B300?

Please Login or Register  to view this content.

Not sure, I believe you have rows and columns mixed up, rows go up and down, columns go left and right.

Maybe just attach a sample workbook, to stop any more confusion.

As far as I can see there is a loop, possibly your paste location is the error, is it pasting to the same range each time?

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

Try this,

Please Login or Register  to view this content.