Sum up similar results into one.

[prefix]

Hey, this one is probably pretty easy, but i just couldn't wrap my head around how to do this, i mean i know how to do it formula wise but not in VBA.

What i need is to sum up all the identical Machine names in column A, so that i get the total produced of that particular machine instead of several lines on one machine.

I will post the workbook in question, in hopes that someone has an easy code for this.

[johnjohns]

use a pivot

rgds

johnjohns

[zbor]

See this solution:

[prefix]

Thanks guys, both are good solutions but i think i will be going with the last one, since it will be easiest to use that with my code. Added to both of your reps

Thanks again :D