Search for text in a column, copy the text in the same row different column, paste to different sheet

  • Dear Learned Friends, i have searched and found similar request but not exact. Any help will greatly be appreciated.

    I have certain text found in sheets "Edging" A1

    I need to match the text with text found in sheets "Cabinets" column AC

    when a match is found, copy the text in same row but column AI

    Paste to sheets "Edging" B1

    stop search.

    Code I have so far cobbled together:

  • Maybe

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!