Hi guys,
Im trying to solve a problem but, obviously i need some help from the experts.
To take things from start, I open a txt file and read the data I need to an array, then I paste the required values on a sheet.
Example A:
Raw Data.PNG
As you can see in column A there are duplicates values from which, with the help of dictionary in vba i sort the list as shown below:
Example B:
Capture.PNG
But the problem is that in the example B i manage to short the list not to exist duplicates values in the column A (Order N.) also in column B (Invoice N.) i manage to link all the invoices with the order N. but in column C (Amount) i want to sum the values for each cell.
like this :
Result.PNG
I would apreciate if anyone can help.
Bookmarks