After you discover the power of automating Excel, you will want to learn more about what VBA can do. So here is my selection of recommended reading and tutorials.
Tutorials to deepen your knowledge of Excel VBA:
A great overall tutorial if you want to get the basics right. Don’t let the version (Excel 2003) put you off as there are few changes between the various versions of Excel – especially as you are starting to learn the language.
On http://www.ozgrid.com/VBA/ you will find great bits of code samples for every day needs, however it is not an end-to-end tutorial. Copy and paste for sure!
Come to think of it, I also like http://www.cpearson.com but you are probably quite busy with the above already!
Books about Excel and VBA
I also like Bill Jelen aka Mr Excel’s books so you might want to give a try to VBA and Macros: Microsoft Excel 2010.
This one, Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access is interesting in that it shows ways to make these applications work together. I did not find the provided examples that relevant to my work but still, they are great to get you practicing some advanced skills.
That’s about it for now. If you have any other favourites of your own, please list them in comments below. Best of luck with your coding !