Create Loop and stop when done

Originally Posted by whtwzzrd88

I have figured out how to everything but the loop part.

I think you should have two loops. The one I listed was the list at B29:B35. So the loop will iterate each cell, but what we need to add is the Range.Find do-loop.

Does each one in the list only appear once in the A18:Y25? (or should that be K25?)

Where is the data being pasted to?