Re: Link to Excel table with filtering enabled

[John Posada <jposada99 -at- gmail -dot- com>]

Thanks

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
the Excel.

On Mon, Jun 4, 2018 at 1:47 PM, Weissman, Jessica R <WeissmanJR -at- state -dot- gov>
wrote:

> John:
>
> 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
>
> Personal
> UNCLASSIFIED
>



-- 
John Posada
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Visit TechWhirl for the latest on content technology, content strategy and content development | http://techwhirl.com

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwhirl.com/email-discussion-groups/ for more resources and info.

Looking for articles on Technical Communications?  Head over to our online magazine at http://techwhirl.com

Looking for the archived Techwr-l email discussions?  Search our public email archives @ http://techwr-l.com/archives