Macros

Here's some links to get you started:

http://www.excel-vba.com/v-introduction.htm
http://www.helpwithpcs.com/tipsandtricks/microsoft-excel-macro-tutorial.htm

http://spreadsheets.about.com/od/excelmacrosandvba/

Gary

You don't say your vb background, but if you don't have any, get some - even the basic syntax and structures.
1 Use free web resources (is that what you wanted to hear?) Try:
VBA
http://www.vba-programmer.com/
http://www.mindspring.com/~tflynn/excelvba.html
http://www.functionx.com/vbaccess/
http://www.excel-vba.com/
http://www.developerfusion.co.uk

VBA Links
http://www.mindspring.com/~tflynn/vbalinks.html

2 Record some actions in macros, then open the VBA editor, get in there and get your hands dirty.

3 Pick up a book like Access Cookbook from O'Reilly, or VBA in a Nutshell.

4 If you hit a problem, send your error message into the ether and see what turns up. Keep it literal and you'll probably find that problem / question has already been hit / asked a thousand times already; and answered several times.

5 If / when you find yourself ready to ask vba-specific questions, use your search engine - there's loads of resources out there!