Macro and summarizing data

Hi,

I recently got great feedback about an issue I had with how to distribute data to several tabs based on whats in column A.
http://www.excelforum.com/excel-prog...o-another.html

Now I am in need of more help, more specifically with how I can add a summarizing feature to the same macro as before.

Is it possible to include in the below code that each time I start the macro it distributes the data based on A (like it does right now) but that it sums up the values of each item on a seperate row?
Below pic shows kind of what I am after.

desired result.png

Please Login or Register  to view this content.

Thanks!

/Ejh

There is a nice tool for it (soobtotals in data ribbon). Of course it can be added to your macro:

Please Login or Register  to view this content.

More natural location for thus macro eould be in normal module, not in the sheet code.

PS. Please edit your post and use code tags - read in forum rules if you don't know how.

Hi,
You can either scan already prepared sheets for rows with sums and add rows below or let's do this from the scratch - hope that code below is quite straightforward.
Why normal module - sheet module shall be mostly used for sheet objects - embedded shapes buttons etc, as well as handlers of events related to the sheet.

Please Login or Register  to view this content.