Reducing size of worksheet after using macro

Hi,
I have a problem where by i run the macro below on a workbook. Each sheet it then produces has 35,000 rows in it, so the total file size is huge (~75MB at the last check). Once the macro has been run, each sheet only has data in the first 3000 or so rows. Is there a way of getting rid of the rows that were activated in the initial loop and hence reducing the file size?
Thanks

Please Login or Register  to view this content.