Autosum Grouped Cells

**joshuarobbins** · 11-24-2015, 11:47 AM

Hello everyone,

I have been trying to create a macro that inserts a space between different values (per below code), but now I also need the macro to autosum the values in cells K and L, within the grouped/ divided rows.

Grouping code:

Please Login or Register  to view this content.

Below is my very poor attempt for the autosum:

Please Login or Register  to view this content.

How would I correct this code, and where would I insert it to make it work, or does that not matter? Thank you in advance for your assistance.

**JOHN H. DAVIS** · 11-24-2015, 11:57 AM

Does this help?

Please Login or Register  to view this content.

**joshuarobbins** · 11-24-2015, 12:27 PM

Hello John, and thank you for the reply. This has helped, however there are still a couple problems. How would I make the macro print the outcome in column P? And is there a way to combine the amounts in column K and L? It looks like it is just doing the sum of Column K, and then the sum of column L. Thank you again for the help.

**JOHN H. DAVIS** · 11-24-2015, 12:55 PM

In Column P, do you want the sum of both Column K and L? Can you provide a sample showing a before and after sheet when the macro is run?

**joshuarobbins** · 11-24-2015, 01:09 PM

Yes, in column P I would like the sum of K and L to be displayed. Below is the requested screenshots. Due to the nature of the report, I had to leave out heading and personal information.

Excel SS.JPG

Excel SS 2.JPG

The second screenshot if after the macro is run.

**JOHN H. DAVIS** · 11-24-2015, 02:42 PM

In your screen shots which Columns are which (K,L and P). Posting a sample with the layout of what you want to happen does not need to include any confidential information. Just some dummy data to show the results.

**joshuarobbins** · 11-24-2015, 03:02 PM

Alright, let's try these:

Excel SS.JPG

Excel SS 2.JPG

**JOHN H. DAVIS** · 11-24-2015, 03:53 PM

Maybe:

Please Login or Register  to view this content.

**joshuarobbins** · 11-24-2015, 05:03 PM

Alright, that worked great actually. Now the final issue I am running into is further grouping my lists. Currently it inserts a space between each of my separate people, based off of an ID in column A. Within each grouped person, there are separate purchases that need to be totaled and posted in column P. Below is a picture to help illustrate:

excel SS 3.JPG

So instead of totaling the entire selection, is there a way to further autosum within the group based on a value in column G? Thank you so much for your help, you've been great.

**joshuarobbins** · 11-25-2015, 09:33 AM

And please disregard the two random screenshots below the main one. Those were previous screenshots I took and removed because they did not best illustrate what I was explaining. Looks like they stuck with the post in error.