Hi JTurk, welcome to the forum.

Without VBA (same as "macros") I don't think you'll be able to accomplish this task. Your best bet would be to use Office 2004 (which still contains VBA) or upgrade to Office 2011 - which from what I've read once again includes VBA.