Macro - Word Search for words beginning with certain text and then Cross Reference Excel to return content from adjacent cell

  • Good morning all,


    Newbie using macros. I have a unique situation that takes me hours to complete which I understand could be completed in a matter of seconds with the right Macro. How can I create a macro that searches a document for words beginning with "SWI_" and then searching an excel document for the same but replacing the original of the word document with the word in an adjacent cell of the excel document?


    Example:


    Word document- look up "SWI442" and find it in the excel sheet. In the adjacent cell the new number is "SWI449". I want to replace the "SWI442" with the "SWI449".


    Any help would be appreciated.

Participate now!

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