I have a range with peoples names in it, next to each name is two income values. In this range some peoples names appear more than once, what I want to do is consolidate the data by adding the values in each income column and then discard those rows that were summed.
I am guessing I need some sort of loop to run through each column and sum the neccesary values all the while deleting already summed rows.
eg, say I have someone named Paul in "Column B", in "column C" his sales are $100, his total sales are $300 in "Column D". Further down the range his name pops up again in "Column B" and his sales are $150 "Column C", total sales are $500. Now I want to consolidate Pauls data by adding the "sales" and "Total sales" and only have his name appear once in this range.
P.S. The sample workbook does a much better explanation.
Bookmarks