Report macro

Hi,

I need to write a macro for a report where I have about 500 material numbers and each have about 10 batch numbers. I need to set the macro to tie up the forecast usage against stock on hand. When I do it manually it takes me days to do can any1 please assist me?