I'd recommend posting an example of your work or creating something similar for us to work with.
VBA has an exacting nature that requires at least some type of foundation for us to code from.

Outside of that, I'd just recommend ample use of Ctrl+H to replace all of 1 term for another a few times.