Forum Discussion

Tom Rhymestine's avatar
Tom Rhymestine
Copper Contributor
Dec 11, 2017

Automate multiple find and replace functions.

I have a large database and need to use find and replace 16 times to update the data. How do I automate the process. I’m thinking about a macro or something similar. I’m just a novice user so please be gentle!
Macros & VBA
Need Help

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 12, 2017

    Tom,

     

    You can almost automate any task in Excel using Macros!

     

    To learn more about Macros follow these links:

    https://support.office.com/en-us/article/Quick-start-Create-a-macro-741130ca-080d-49f5-9471-1e5fb3d581a8

    https://support.office.com/en-us/article/Automate-tasks-with-the-Macro-Recorder-974ef220-f716-4e01-b015-3ea70e64937b

    http://www.excel-easy.com/vba/create-a-macro.html

Resources