Bots.Doctor
Active Member
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.
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.