I am trying to write a macro that will run a find for pre-selected words and replace them with one of several pre-selected word options ultimately chosen by frequency in another document. Think of it like an Ad libs game.



Example: "The sky is blue"

Basic colors are pre-grouped, any instance of a color is picked up by the find and replaced with the most frequently used color in another document.

Can someone please help me with this example so i have something to work with?