Not in one post, probably not in 6 months.
Macros are easy to get started with -- turn on the recorder, do something, turn off the recorder. Making that recorded code flexible takes time adn understanding of the language.
Real understanding of VBA takes time too -- you will be learning a programming language. but if you stick with it, it's very rewarding.
Try...
Books --
VBA and Macros for Microsoft Excel by Bill Jelen and Tracy Syrstad (from the MrExcel Store on this site)
Power Programming with Microsoft Excel VBA by John Walkenbach
Web --
Google VBA Tutorial
Also check out the thousands of threads on this site.
Denis