Hi,

Have a big problem - don't know If its possible to solve it with VBA. If the socialsec, date, fruit is same then save it into a temp or something sum quantity and print out as 1 line else different rows.

Have a sheet with following data:

SocialSec Date Fruit Quantity
12345 2015-02-02 Apple 5
12345 2015-02-02 Apple 3
11223 2015-02-01 Banana 1
11223 2015-02-01 Pear 1

Printout in Sheet2:

SocialSec Date Fruit Quantity
12345 2015-02-02 Apple 8
11223 2015-02-01 Banana 1
11223 2015-02-01 Pear 1

Is this possible to solve? Best way to solve it thru an array, or? Feels impossible with VBA.

Thanks for help!