Need Macro Assistance - Summarising Multiple Columns from unique username

**Weekes** · 10-31-2014, 12:21 PM

Hey There. New to the forum but i hope you guys could help me

Heres my example data:
Example.jpg

So i have a list of re-occurring usernames which show different quantities in the cells to the right.
The outcome i need to provide would show just one instance of their name, but with a total of each SUM column.
(i have placed an example in the image above should my summary not make sense!)

Now that sounds basic and i could probably get there myself, however here's the caveat...

The usernames will always be variable, never the same names.
In the example are JIM, BOB and SAG. However in the next lot of data we may have REG, SAL and MIK multiple times.

So i guess i need help in discovering a macro function that will allow me to total every SUM column for each username, no matter how many times that username appears in my data.

Hope that makes sense, and there is somebody who can help

Thanks
Jordan

**Weekes** · 10-31-2014, 12:25 PM

Will this work :S

Example.jpg

**Leith Ross** · 10-31-2014, 02:31 PM

Hello Jordan,

Welcome to the Forum!

To help you with this problem, you would need to post your workbook. We need to see how the data is

arranged, what formulas you are using, etc. Otherwise, we are just guessing at what you need.

Please provide before and after examples of your data along with any notes you would like to include.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.