Hello, could someone please help me with a VBA solution to my following Excel 2003 problem:
Please find attached a copy of my Duplicates.xls spreadsheet (contains dummy data only).
What I need please is for Excel VBA to lookup duplicates in column C and to sum the quantities against these duplicates that are shown in column F. The summation figure needs to be populated in column Q against the first instance of the duplicate showing in column C. All the remaining duplicate rows need to be deleted.
For example:
In cell C2 and C3 shows duplicate Part Numbers. The sum of the Qty Rx is 1
This summation figure needs to be populated into cell Q2
Row 3 needs to be deleted
Another example:
In cells C22, C23 and C24 show duplicate Part Numbers. The sum of the Qty Rx is 2
This summation figure needs to be populated into cell Q22
Rows 23 and 24 need to be deleted
Last example:
In cells C37, C38 and C39 show duplicate Part Numbers. The sum of the Qty Rx is 0
This summation figure needs to be populated into cell Q37
Rows 38 and 39 need to be deleted
If this does not make sense, please let me know.
Any help would be greatly appreciated.
Kind regards,
Chris
Bookmarks