RE: Link to Excel table with filtering enabled

Subject: RE: Link to Excel table with filtering enabled
From: "Weissman, Jessica R" <WeissmanJR -at- state -dot- gov>
To: John Posada <jposada99 -at- gmail -dot- com>, Tech Writers <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 4 Jun 2018 17:47:56 +0000

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


Follow-Ups:

References:
Link to Excel table with filtering enabled: From: John Posada

Previous by Author: Re: Fillable form/checklist - what to call it?
Next by Author: RE: Consistency with screenshots
Previous by Thread: Link to Excel table with filtering enabled
Next by Thread: Re: Link to Excel table with filtering enabled


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads