Combine specific line items on invoice

[GregStewartPTC]

I am needing a macro to combine/sum two line items when they exist together on an invoice. They do not exist on every invoice, and they do not always exist together on an invoice. I've attached an example of the raw data that I am working with. Invoice numbers are in column A, item numbers in column F, amounts per item in column L. The two item numbers are UN0000075 AND UN0000083. Item number ending 83 will never exist without 75, but 75 can exist without 83. Ideally I would like for the items to be summed onto the row containing item number ending 75, and then the row with item 83 removed completely, and the item description changed to Tax.

Thank you in advance for any help you can provide.

[Mumps1]

I'm not sure if I understood correctly but try this macro on a copy of your workbook.

Please Login or Register  to view this content.

[GregStewartPTC]

Thank you for the quick response! It appears to work on a very small selection of data, but when applied to a larger data set I still see several that were missed. I've uploaded a 2nd example copy with a larger dataset.

Thanks again for your help.

[Mumps1]

Could you please attach another copy of your file highlighting the data/rows that were missed with a color so that they are easy to see?

[GregStewartPTC]

Updated example attached.

Thank you.

[Mumps1]

Try:

Please Login or Register  to view this content.

[GregStewartPTC]

Thank you again for the reply. This works wonderfully! Marking the thread as solved and +rep.

Have a great day!

[Mumps1]

You are very welcome and thank you for the rep.