RE: Link to Excel table with filtering enabled

["Weissman, Jessica R" <WeissmanJR -at- state -dot- gov>]

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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
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