Forum Discussion
Tom Rhymestine
Dec 11, 2017Copper Contributor
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 b...
Haytham Amairah
Dec 12, 2017Silver Contributor
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