|I'm not sure that you need a macro. I can't see your spreadsheet from where I am sitting, but have you considered this method?|
1 - Use the Advanced Filter feature to create a list of unique transaction ID's
2 - In the next column, use the SUMIF function to total all sales for each unique ID.
If that won't work, you'll need to explain why by supplying more detail regarding the layout of your sheet. If a macro is needed, then we are going to need the layout detail anyway.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.