rdelosh74
07-21-2014, 07:39 AM
Need some help on this please.
Column A has part numbers in it. Could be numbers or letters or a mixture. I need to find all duplicates. And SUM the totals in column H, I and J (separately) if there is a duplicate for that row.
And then to delete the entire row that had the duplicate information. Leaving just the first instance of the part number.
I have enclosed a sample to show what I mean.
This needs to be set up to always run on the last sheet of the workbook.
There could be no duplicates for a row, or up to 50 plus duplicates.
In the sample file. I have two tabs, Before and After. Before the macro is run, and after the macro is run. The after is just for example and I do not need another sheet added.
Thank you very much.
11996
Column A has part numbers in it. Could be numbers or letters or a mixture. I need to find all duplicates. And SUM the totals in column H, I and J (separately) if there is a duplicate for that row.
And then to delete the entire row that had the duplicate information. Leaving just the first instance of the part number.
I have enclosed a sample to show what I mean.
This needs to be set up to always run on the last sheet of the workbook.
There could be no duplicates for a row, or up to 50 plus duplicates.
In the sample file. I have two tabs, Before and After. Before the macro is run, and after the macro is run. The after is just for example and I do not need another sheet added.
Thank you very much.
11996