Copying all instances of a row match to another sheet

The below code copies over a row from Sheet1 that contains a certain criteria (input via msgbox) to Sheet2. Every time it's run, it will stack these rows into Sheet2, one after the other, without overwriting anything.

I love this macro. It works perfectly for me...except for one problem. It only copies over one instance of each match. I would like it to copy over all instances - multiple rows if they exist. How can I do this?

I would prefer not start over with a new code unless necessary.

Thanks!

Please Login or Register  to view this content.

Is the data you are searching for in one particular column or can it be anywhere on your sheet?