Hey, I'm looking for someone to write a short VBA script that will: 1. Loop through worksheet 1 2. Get the first word in cel B 3. Combine the word with the first 2 letters from the first word in cel C (For example: "Washington Va") 4. Those combined will be used as a term to look for in Worksheet 2. 5. If the term is found in worksheet 2, data from cel A will be copied. 6. Data will be pasted in cel O in worksheet 1 in the corresponding search term. 7. Continue the loop until the whole worksheet is done. It is urgent. PM me.