TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:Re: Link to Excel table with filtering enabled From:John Posada <jposada99 -at- gmail -dot- com> To:"Weissman, Jessica R" <WeissmanJR -at- state -dot- gov> Date:Mon, 4 Jun 2018 13:56:51 -0400
I don't want copy in because there are almost 200 documents that will get
reviewed every 12 months (they are procedures and my governance says they
have be reviewed every year) and when they are, I might have to update that
section all over again. As a link with filter, all I have to do is update
On Mon, Jun 4, 2018 at 1:47 PM, Weissman, Jessica R <WeissmanJR -at- state -dot- gov>
> I think you'd have to do this with a Word macro that calls Excel and
> passes parameters that indicate which entries to show. On the Excel side
> it would filter the big table and make a temporary sheet with the filtered
> results. The link in the Word doc would be a button that executes the
> macro to do all this.
> Might not be worth the trouble to create or maintain. Why not just copy
> the relevant items manually into each Word doc?
> If you think you'd be revising the glossary wording and want to keep it
> updated, you might be able to transfer the Excel sheet into a Word doc and
> use bookmarks to grab current text.
> Disclaimer: these are just ideas and there may well be a much simpler way
> to do it. No matter what way you chose, you'd need to find a way to
> indicate which glossary items are relevant for the document.
> - Jessica
Visit TechWhirl for the latest on content technology, content strategy and content development | http://techwhirl.com