This is my first post.
I am a procedure writer at a power plant. In short, I need to be able to manually select text (a Document Number) in my Word document, and have the Word macro search that text string for data (the corresponding Document Title) in an Excel spreadsheet found on our lan. The macro will then replace the selected text in the Word document with the data pulled from the spreadsheet.
Rather than making a huge post, I have attached a Word document with specifics, plus a sample source Excel spreadsheet from which data will be pulled.
Any help (even feedback about me doing this wrong) would be greatly appreciated! I want to learn.