File/Workbook created by Macro is making it heavier, unable to find the reason

[e4excel]

Dear Forum,

I am creating 4 Sheets from a Main Sheet by Filtering Data based on different values in a fixed column, then the Filtered Rows are automatically pasted in the respective sheets.
Then these 4 Sheets are creating another file.

The same thing done manually by Grouping the 4 SHeets and then Move Copy into a New workbook also makes the file heavier.

Everything works fine however though the data is not much the file is very heavy, so what do i do to make it of appropriate size ?

What could be the reason for this to happen ?

Regards
e4excel

[e4excel]

Please find the codefor pasting data in 4 different sheets

Please Login or Register  to view this content.