Tags:
  1. Bots.Doctor

    Bots.Doctor Active Member

    Feb 21, 2018
    40
    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 Active Member

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

Share This Page