I have a worksheet which has over 1000 rows of data. Some of the rows have
corresponding data in the first 5 columns and then new data in the following
10. I need to filter the document so that a match is performed on the first
few columns then the data in the remaining columns is added together. I know
I can add a filter and then look at each case but I would need to do this
nearly 300 time to have the data in the end of the columns consolidated. I
have also looked at doing this through a pivot table but I have multiple
columns that need additing together.

Thanks
Dan