finding data in duplicate rows, revising row data and deleting duplicates

Hello, I have a worksheet that has over 4500 rows and about 20 columns of information. A serial number may be listed multiple times. I am looking to compare the information and if duplicated consolidate the duplicated data to one row.

Here's an example of te worksheet:

ColA ColB ColC ColD ColE ColF
07002 E046 NYNJ EAST 19,581
07002 E046 NYNJ EAST 475.30
07002 E046 NYNJ EAST 950.60

End result I would like to see:
ColA ColB ColC ColD ColE ColF
07002 E046 NYNJ EAST 19,581 1425.90

I DO NOT know how to do macros (Yeah, excel dummy) so I need help. PLEASE.

Hi

Create a spreadsheet using your example data.

Put headings in A1:E1 of sheet1, and your example data in A2:E4.
Make sure you have a sheet2 in your workbook.
Put the macro below into a general module and run.

Please Login or Register  to view this content.

It will add a temporary working sheet which will be deleted, and the output will go into sheet2.

HTH

rylo