The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won't do it. There are workarounds you can use to get the same result, however.
If you decide to create a master document, it is easy to do by just adding one or more subdocuments to an existing document. This tip shows how you can use the outlining capabilities of Word to accomplish the task.
Read this WordTip: Creating a Master Document Using Existing Subdocuments
Microsoft Word Tips - Learn Word Faster!
Your laser printer probably does a great job in putting black type on the paper. If you want to print gray tones, the results might not be so great. Here is a tip on a way you might be able to get even better looking gray tones from that printer.
AutoText is a timesaving feature that allows you to assign a word, phrase, paragraph, or graphic to a mnemonic name. Type the name, press a shortcut key, and the mnemonic is replaced with the word, phrase, paragraph, or graphic. Discover how you can take advantage of this powerful tool.
With a long list of items in a worksheet, you may want to determine the last time a particular item appeared in the list. There are a couple of ways you can tackle this problem, as described in this tip.
It appears that Word doesn't allow you to define custom dictionary entries that include ampersands. There are ways you can work around this apparent problem, including a way that relies on AutoCorrect to mark your text so it is ignored by the proofing tools.