Linking an Excel cell location to Word document

%3CLINGO-SUB%20id%3D%22lingo-sub-1308064%22%20slang%3D%22en-US%22%3ELinking%20an%20Excel%20cell%20location%20to%20Word%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308064%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20cell%20in%20an%20excel%20worksheet%20that%26nbsp%3B%3CSPAN%3Euses%20a%20dropdown%20list%2C%20providing%20an%20outcome%20(using%20a%20VLOOKUP%20function)%20from%20another%20cell.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20want%20to%20link%20the%20(changeable)%20text%20content%20from%20this%20outcome%20cell%20to%20a%20specific%20place%20(bookmark)%20in%20a%20word%20document.%3C%2FP%3E%3CP%3EIn%20a%20trial%2C%20I've%20been%20able%20to%20directly%20link%20a%20cell%20content%20to%20a%20bookmarked%20location%20in%20Word%20but%20it%20seems%20excel%20doesn't%20like%20to%20work%20with%20changing%20values%20such%20as%20when%20a%20drop%20down%20list%20(validation%20table)%20is%20introduced.%3C%2FP%3E%3CP%3ECan%20you%20suggest%20a%20shortcut%20to%20achieve%20my%20objective%20please%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1308064%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have a cell in an excel worksheet that uses a dropdown list, providing an outcome (using a VLOOKUP function) from another cell.

I want to link the (changeable) text content from this outcome cell to a specific place (bookmark) in a word document.

In a trial, I've been able to directly link a cell content to a bookmarked location in Word but it seems excel doesn't like to work with changing values such as when a drop down list (validation table) is introduced.

Can you suggest a shortcut to achieve my objective please? 

0 Replies