Hello,
I believe i can help you with this project. I've worked with pretty complicated macros before, so i can quickly solve your problem, however i did not quite understand what you really want to be done in the macros, so if you could contact me so we can further discuss that would be great.
I look forward to working with you.
Best regards,
Vasco.