VBA code to copy rows to another sheet and sumup its columns

Please i need help to create macro to copy rows to another sheet and sumup its columns .. please download file for clear understanding

thank you

Perhaps a macro like this?

To test run macro "SplitData". Macro will first delete all sheets except "Sheet1" then find all unique ID's in column A of "Sheet1" and use these values for autofilter settings and creating new sheets.

Alf

FWIW:

Please Login or Register  to view this content.