Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access
It is the best book if you want to learn Marcros. its a Book by Cindy Meister, Juan Pablo Gonzalez, and Suat Ozgur.
Hopeit is helpful.