I am working with a template that I update each week if not more. The updates typically include updating names via Find & Replace and make adjustments to dollars. All adjustments are done by column.

Is there a way to create a Find & Replace Macro? If so, is it possible to have it replace information based on information on another sheet or in another location? My goal would be to be able to open the document, run the Macro, and then save the document.

If I need to provide more information please let me know.

Thank you.