Tags:
  1. Bots.Doctor

    Bots.Doctor Well-Known Member

    Feb 21, 2018
    80
    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.
     
  2. Bots.Doctor

    Bots.Doctor Well-Known Member

    Feb 21, 2018
    80
    Thanks, the work is done.
     

Share This Page