VBA Auto calculate and combine a list

[Lars1]

Hi

I have a list of products where i would like to calculate the dublets into one line.

is it possible to do this with a macro / VBA ?

Product	Description	#
1702	Product 1	200​
1702	Product 1	300​
1702	Product 1	200​
1702	Product 1	400​
1900	Product 20	80​
1900	Product 20	90​
1900	Product 20	60​
1900	Product 20	40​
1900	Product 20	12​
1900	Product 20	18​
1900	Product 20	20​
1900	Product 20	30​
1984	Product 123	125​
1984	Product 123	100​
1984	Product 123	75​
1984	Product 123	200​
1984	Product 123	100​
1984	Product 123	90​
1984	Product 123	110​
1984	Product 123	100​
3620	Product 1204	10​
3622	Product 1205	20​
3630	Product 1206	30​
3632	Product 1207	40​
3664	Product 1208	50​
3710	Product 1209	60​
3720	Product 1210	70​
3721	Product 1211	80​
3722	Product 1212	90​

 

[smozgur]

@Lars1: I noticed you marked your last post as the solution.

Did you solve your question yourself or still trying to reply to the other experts' questions they asked you regarding your data?

 

[Lars1]

@Lars1: I noticed you marked your last post as the solution.

Did you solve your question yourself or still trying to reply to the other experts' questions they asked you regarding your data?

@smozgur i simply find out that i don´t need this function anyway.