Hello,
I have a file that was originally built in Word and is now in Excel.
The file is set up to link the Key project information to the Export tab.

Originally the user would do a Find and replace for each line item. I'd like to automate that with a Macro (thought about stringing the text but its over 255 and it gets goofy)

For example:
The export tab has 2 columns :
Column B Column C
Row 1 <FACILITY> Lambton College
Row 2 <UTIL2> Natural Gas
Row 3 <UTILITY DATA RANGE> May 2010-April 2011


The Former word document :
XXXXX was asked by <FACILITY> to analyze its ......

The user would have to do a Find and replace for each item. I'm looking for a code (marco) that says:

On Export tab -->Find <FACILITY> replace with Cell C1 (in this case "lambton College") on Sheet One, two three etc
On Export tab -->Find <UTIL2> replace with Cell C2 (in this case "Natural Gas") on Sheet One, two three etc