Macros for MS Office are written in VBA (Visual Basic for Applications); no, they are not supported on the Mac version (2008). Yes, on Office 2004, but only what is based on VB 5, not on VB 6 (2000/2002/2003).
You can write AppleScripts for MS Office, but they cannot be transferred to Windows versions.
Perhaps if you know the languages, Python, Perl, or Ruby might be cross-platform usable.
Numbers does not support VBA nor does it support AppleScript.